Forum Discussion
Create a dynamic measures using field parameter measure values
frankGB , Not very clear. One it simple Switch values on Row in Matrix Visual
https://www.youtube.com/watch?v=M5PvQUy-L_4
If not then you need to use the calculation group
Calculation Groups- Measure Slicer, Measure Header Grouping, Measure to dimension conversion. Complex Table display: https://youtu.be/qMNv67P8Go0
Super UserfrankGB , Not very clear. One it simple Switch values on Row in Matrix Visual
https://www.youtube.com/watch?v=M5PvQUy-L_4
If not then you need to use the calculation group
Calculation Groups- Measure Slicer, Measure Header Grouping, Measure to dimension conversion. Complex Table display: https://youtu.be/qMNv67P8Go0
Thank you Amit,
the Matrix visual works if you don't use any calculations. But because in the example I need a filtered calculation using the calculated measure, it will not work when the calculation becomes more complex.
If I for exaple want to calculate a change percentage, I will need a calculated measure like below.
Calculated Measure = CALCULATE(SUM('Measure-Parameter'[Metric Fields]), 'Date-Table' = Date(2022,01,01) /
CALCULATE(SUM('Measure-Parameter'[Metric Fields]), 'Date-Table' = Date(2022,01,02)
I had a quick look at the Calculation Group. This might be a feasible solution actually. Let me try this. It seems using Calculation Groups and using dynamic period calculation groups, would remove the need to the field paramters anyway.