Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
8 years ago
Solved

Dynamic Measure Selection and YOY Calculation

Hello,   I am fairly new to Dax and M langauage, but I have mananged to throw a report together that works, but it is missing some dyamic features(Please forgive any terminologies that are incorrec...
  • Ashish_Mathur's avatar
    Ashish_Mathur
    8 years ago

    Hi,

     

    Yes, you will have to write that formula for each measure.

Anonymous's avatar
Anonymous
Not applicable
8 years ago

Hi,

 

Once again thank you for your response. I think I maybe making the question more complicated that it has to be. Essentially I am just trying to see how to filiter the measures(about 30) in the format seen above(the first table filter that row). I think I've got the YOY calculation, but just to be sure For the YOY calculation do I have to right that for each measure? Where Amount= SUM(Sales[Data]))

SUM(Sales[Quantity)...

etc...

Ashish_Mathur's avatar
Ashish_Mathur
Super User
8 years ago

Hi,

 

Yes, you will have to write that formula for each measure.

  • Anonymous's avatar
    Anonymous
    Not applicable
    8 years ago

    Great! I know where to go from there. In terms of filtering the measures would you be able to provide a little more insight as how to that works. I went through the previous suggested solution and was not able to filter the measures. Once again thank you for your help! This has been a big road block in using measures for advanced calculations and measures.