Forum Discussion

ptmuldoon's avatar
ptmuldoon
Resolver I
2 years ago
Solved

Multiple Dynamic Measures?

I currently have a dynamic measure that works that I can use a slicer to update the value/measure.   An example, being, I have measures created to compute "Rate", "Last 7 Rate", and "MTD Rate".

 

And my Dynamic measure looks like the below:

Dynamic Measure = 
SWITCH (
    VALUES ( 'Measures List'[Measure Name] ),
    "Rate", [Rate],
    "Last 7 Rate", [Last 7 Rate],
    "MTD Rate", [MTD Rate]
)

 

But I would like to try and modify this where I can I list out multple Measures in a Table/Grid.   I also have measures for things like "Qty", "Last 7 Qty", "MTD Qty"

 

Do I need to make a Dynamic Measure for Qty and others and then somehow connect them to another measure/slicer that lists "Last 7", "MTD", etc?

 

So the hope is that I can include columns in table/grid for Rate | Qty | and others.  And via a slicer chose "Last 7", "MTD", etc. and have each column update.

 

1 Reply