All Function not working correctly

[mantaga]

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 🙂

[Fowmy · Accepted solution]

@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

[sturlaws]

Hi @mantaga 

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

Cheers,
Sturla

[mantaga]

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

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

Thanks!

[sturlaws]

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

[amitchandak]

@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

[harshnathani]

Hi @mantaga ,

Just use this measure

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

Regards,

Harsh Nathani