Forum Discussion
All Function not working correctly
Hello,
i have these 2 simple DAX Measures, with which I'm trying to calculate the percentage of each category. Therefore I use the All Function, but somehow it only works if I use the "criteriaID" instead of only "criteria".
All Column not working = CALCULATE([Invoice Category], ALL( AnalysisOfInvoiceTypesHistorie[criteria]))
All Column working = CALCULATE([Invoice Category], ALL( AnalysisOfInvoiceTypesHistorie[criteriaID]))
Does anybody have an idea on this ? I was thinking of the length of criteria?!
Thanks for any hint 🙂
Try it this way, include the key in ALL,
All Column = CALCULATE([Invoice Category], ALL( AnalysisOfInvoiceTypesHistorie[criteria]),
AnalysisOfInvoiceTypesHistorie[criteriaID]))
________________________
Did I answer your question? Mark this post as a solution, this will help others!.
Click on the Thumbs-Up icon on the right if you like this reply 🙂
6 Replies
Hi mantaga ,
Just use this measure
ALL Values = CALCULATE([Invoice Category], ALL( AnalysisOfInvoiceTypesHistorie)
Regards,
Harsh Nathani
mantaga , You can try
CALCULATE([Invoice Category], allcrossfiltered( AnalysisOfInvoiceTypesHistorie))
CALCULATE([Invoice Category], ALL( AnalysisOfInvoiceTypesHistorie)) //
How to use allcrossfiltered and removefilters
https://www.linkedin.com/pulse/five-recent-power-bi-functions-you-should-use-more-often-amit-chandak
Try it this way, include the key in ALL,
All Column = CALCULATE([Invoice Category], ALL( AnalysisOfInvoiceTypesHistorie[criteria]),
AnalysisOfInvoiceTypesHistorie[criteriaID]))
________________________
Did I answer your question? Mark this post as a solution, this will help others!.
Click on the Thumbs-Up icon on the right if you like this reply 🙂
