我正在尝试获得DAX中的度量值的差异，但要获得0
我想使用dax aadpmau_increase = [aadpmau_end] - [aadpmau_start]获得两个测量
的
值
之间
区别启动和结束由日期选择器过滤器设置的值。看来该计算始终将两者都视为平等，因此返回0
aadpmau_start =计算（aadpmau_sum]，filter（dimdate，dimdate [startDate] = dimdate] = dimdate [startDate] [startDate]）
）计算（aadpmau_sum]，过滤器（dimdate，dimdate [enddate] = dimdate [enddate]）））
AADPMAU Increase =
var at_end = AADPTable[AADPMAU_End]
var at_start = AADPTable[AADPMAU_Start]
return at_end - at_start
I will like to get the difference between two measure values using DAX
AADPMAU_Increase = [AADPMAU_End] - [AADPMAU_Start]
But when I do the subtraction, I am getting 0
I have tried different things, but nothing is working
The two values are start and end values that are set by date selector filters. It appears that the calculation is always treating both as equal therefore returning 0
AADPMAU_Start = CALCULATE(AADPTable[AADPMAU_Sum],FILTER(DimDate,DimDate[StartDate] = DimDate[StartDate]))
AADPMAU_End = CALCULATE(AADPTable[AADPMAU_Sum],FILTER(DimDate,DimDate[EndDate] = DimDate[EndDate]))
AADPMAU Increase =
var at_end = AADPTable[AADPMAU_End]
var at_start = AADPTable[AADPMAU_Start]
return at_end - at_start
如果你对这篇内容有疑问，欢迎到本站社区发帖提问 参与讨论，获取更多帮助，或者扫码二维码加入 Web 技术交流群。
绑定邮箱获取回复消息
由于您还没有绑定你的真实邮箱，如果其他用户或者作者回复了您的评论，将不能在第一时间通知您！
发布评论