Forum Discussion
mantaga
6 years agoFrequent Visitor
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" i...
- 6 years ago
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 🙂
sturlaws
6 years agoResident Rockstar
Hi mantaga
just wondering, is AnalysisOfInvoiceTypesHistorie[criteria] sorted by AnalysisOfInvoiceTypesHistorie[criteriaID] in your model?
Cheers,
Sturla