Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi, I have a matrix with two rows that are used as a header, the first header row uses as a group under which there are several groups. Every time I add one new group, the same group appears to me again and again and again. There is no connection between the groups and therefore there is no data either and the other column is empty. How do I cancel this connection?
What is the metric used for in your example? And where do I put the measure I created? in columns?
Hi @Livnat ,
In this case without knowing how the metrics are setup and the calculations done believe waht you are missing is group that allows you to have the calculation merged between the groups for example if you have a table similar to this:
Header 1 | Header 2 |
Group1 |
Low Level1 |
Group1 | Low Level2 |
Group2 | Low Level3 |
Group2 | Low Level4 |
Now if you add a switch stament similar to this:
Values=
SWITCH(SELECTEDVALUE(Table[Header 2]),
"Low Level1", [Metric1],
"Low Level2", [Metric2],
"Low Level3", [Metric3],
"Low Level4", [Metric4]
)
The using this metric on the values of the matrix and the table values on the headers you will get the values has you need.
Regards
Miguel Félix
Proud to be a Super User!
Check out my blog: Power BI em PortuguêsCovering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
107 | |
100 | |
78 | |
64 | |
58 |
User | Count |
---|---|
148 | |
113 | |
97 | |
84 | |
67 |