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.
The calculation groups seem to work. The video is quite useful.
Thank you for pointing me to this solution.
