Grouping Measures

[jhsimb]

Hi. I need help with the following, each filter selection that show me two measures (or more):

It is possible that?

Thanks.

[jhsimb · Accepted solution]

Hi. Thanks but the complex answer help me to find a simple and perfect solution for my problem.

Thanks again for your time and guidance.

[BA_Pete]

Cool, glad you got it sorted.

Was your solution something that you can share here that might help future users solve the same problem?

Pete

[BA_Pete]

Hi @jhsimb ,

You want to use the Field Parameters function in Power BI Desktop.

Make sure your version of PBI Desktop is at least May 22 release or later then check out this guide:

https://endjin.com/blog/2022/06/how-to-dynamically-switch-between-measures-in-power-bi-visuals-with-... 

Pete

[jhsimb]

Thanks but it only works with one measure. I need that each filter selection show two or more measures at the same time in the matrix not just one.

[BA_Pete]

Ah, ok. I think there's two options:

-1- Just put all measures into the parameter table and let your end users elect all the measures they want to display.

-2- Create a parameter table for each different measure type (Totals, Parcials etc.), relate the different tables on the [ParameterName Order] columns, and apply all parameter tables to your visual.

For example, I've created my first parameter table as 'Actual' (you might do 'Parcials', for example), and added all the 'Actual' measures that I want:

Then I do the same, IN THE SAME ORDER, for the forecast values:

Now, I relate these two tables in the model, like this:

Now I just throw both parameter tables into my visual and use the Actual parameter table for the slicer:

You'll want to do some fiddling to get the names/labels how you want them, but I think this is the best/only(?) way to do this.

Pete