Forum Discussion

mantaga's avatar
mantaga
Frequent Visitor
6 years ago
Solved

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...
  • Fowmy's avatar
    6 years ago

    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