Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hello friends,
***Edited***********
I think I've solved it.
This calculation is WRONG:
Running Sales Apples = CALCULATE([Running Sales],FILTER(Sales,Sales[Product]="Apples"))
And this one is right:
Running Sales Apples = CALCULATE([Running Sales],Sales[Product]="Apples")
So without FILTER() it is working.
Can anyone explain it, please?
********************
I have a simple Sales Fact Table and a Calendar table.
I have a Running Sales Amt which is working fine.
They are different on dax engine. The similar thread in stackoverflow below and two blogs may help you understand the difference:
https://stackoverflow.com/questions/50506030/dax-calculate-function-with-and-without-filter
Blogs:
https://www.red-gate.com/simple-talk/sql/bi/using-the-filter-function-in-dax/
https://exceleratorbi.com.au/the-filter-function-in-dax/
Community Support Team _ Jimmy Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Thanks, I've looked at all of the articles.
Nowhere could I find the answer - why doesn't my Running Total work?
I did include ALL(Calendar) - and it is working until I do FILTER(Sales,...)
Please help to understand
Thank you
I think I solved it.
This calculation is WRONG:
Running Sales Apples = CALCULATE([Running Sales],FILTER(Sales,Sales[Product]="Apples"))
And this one is right:
Running Sales Apples = CALCULATE([Running Sales],Sales[Product]="Apples")
So without FILTER() it is working.
Can anyone explain it, please?
Sorry, @FrankAT
ALLEXCEPT doesn't fit because there are other fields in Fact table that can be drillable.
The solution is on the surface, why the plain FILTER is not working?
Hmm, well, see attached and let me know what you think:
@Greg_Deckler thanks, but SUMX is not the solution I am looking for.
Because of ALL(Sales) - I cannot drill down to details....
When there are other fields in the Sales table - your measure will return same amount for all of them.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
114 | |
99 | |
83 | |
70 | |
60 |
User | Count |
---|---|
150 | |
115 | |
104 | |
89 | |
65 |