topic Re: All Function not working correctly in DAX Commands and Tips

All Function not working correctly

mantaga — Thu, 06 Aug 2020 13:49:27 GMT

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 🙂

Re: All Function not working correctly

Anonymous — Thu, 06 Aug 2020 14:10:05 GMT

Hi mantaga ,

Just use this measure

ALL Values = CALCULATE([Invoice Category], ALL( AnalysisOfInvoiceTypesHistorie)

Regards,

Harsh Nathani

Re: All Function not working correctly

amitchandak — Thu, 06 Aug 2020 14:37:30 GMT

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

Re: All Function not working correctly

sturlaws — Thu, 06 Aug 2020 15:08:05 GMT

Hi mantaga

just wondering, is AnalysisOfInvoiceTypesHistorie[criteria] sorted by AnalysisOfInvoiceTypesHistorie[criteriaID] in your model?

Cheers,
Sturla

Re: All Function not working correctly

mantaga — Thu, 06 Aug 2020 15:32:51 GMT

sturlaws good point - yes that's the case...

Why does this sort by value prevent the all function to work ?

Thanks!

Re: All Function not working correctly

sturlaws — Thu, 06 Aug 2020 15:39:44 GMT

https://www.sqlbi.com/articles/side-effects-in-dax-of-the-sort-by-column-setting/

Re: All Function not working correctly

Fowmy — Thu, 06 Aug 2020 17:57:41 GMT

mantaga

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 🙂

YouTube, LinkedIn