Get certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare now
I have a table with measure:
TodayValSI = CALCULATE(SUM(SalesInOut[Amount])/1000000,FILTER( ALL( SalesInOut[DateID]), [DateID] = [MaxDate] ),SalesInOut[SalesType] = "I", SalesInOut[FreeItem] = FALSE())
Measure MaxDate:
MaxDate = CALCULATE(MAX(SalesInOut[DateID]), ALL(SalesInOut[DateID]))
I create a table with2 columns: ProductLine and TodayValSI.
I create a sclicer DateID to filter my table.
If I not filter, data in my table display not correct.
But if I filter MaxDate (2017/05/31), data in my table display correct.
Why?
Am I missing something?
This is link my report: https://drive.google.com/file/d/0B1L_chy-uFDKMTJGZHJYc3hiM1E/view?usp=sharing
Solved! Go to Solution.
Your issue is on your dummy measure [MaxDate].
You limit the context into entire Table so that on grand total level, it will always take the max date in the table which is "2017/5/31"
Just remove the ALL() part, it will return correct result.
Regards,
Your issue is on your dummy measure [MaxDate].
You limit the context into entire Table so that on grand total level, it will always take the max date in the table which is "2017/5/31"
Just remove the ALL() part, it will return correct result.
Regards,
Check out the October 2024 Power BI update to learn about new features.
Learn from experts, get hands-on experience, and win awesome prizes.
User | Count |
---|---|
111 | |
95 | |
92 | |
86 | |
69 |
User | Count |
---|---|
162 | |
129 | |
125 | |
104 | |
98 |