Forum Discussion
Grouping Measures
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
Hi,
I couldn't understand how it will show all 3 measures together if nothing is selected? Kindly please explain. Thanks!
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
Hi amitchandak , I saw the video that you have shared. Great video. I was able to get the slicer measure as I required.
However, in the video you have also grouped Net and Net Target together under "Actuals" and "Target". But in my case, I have Actuals, Targets and Projections. How do you suggest I should add all three into the DAX that you have created?
I tried using the following DAX but it is throwing an error, which I couldn't understand. Kindly please explain.
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 !