Forum Discussion
Solved
Grouping Measures
Hi Everyone, I have a Revenue, Projections and Targets table, for which I have created 3 simple DAX Measures. 1. Revenue = sum(Revenue [invoice_amount])/10^5 2. Target = sum(Targets [targe...
saumitra , Please explore field parameters or calculation groups
Calculation Groups- Measure Slicer, Measure Header Grouping, Measure to dimension conversion. Complex Table display : https://youtu.be/qMNv67P8Go0
amitchandak It is not throwing the above error now. It may be because I had copied the Calculation Group like you had, so something must have caused the error.
However, what dax needs to be written in case you have more than 2 categories? I tried the above dax but it doesn't work. Nor does the max function. Kindly help. Thanks.
I rewatched your video and tried again. It works now. Thanks amitchandak !