cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
MKAS
New Member

"Show on Rows" not functioning for Matrix

Hi 

I am trying to replicate the logic as it appears in the GIF.

2021-07-24_16-10-41.gif

I am developing the functionality through using a matrix table, calculating two measures in PowerBI, and using a non-related filter.

One of the measures is calculating the Preise, and the other one is to calculate the Unit.

The user should have the ability to choose between calculating the rents monthly or per square meter.

The applied logic should be for only one category, which is the property rental and not the other categories i.e it needs to evaluate it at a row context.

Using PowerBI, the logic for calculating the price is working well, but it is not for the Unit.

It would have worked with the use of "show on rows", but that is not working for me.

The calculated Unit measure stays in values but not moving to rows (where it should be) in the Matrix visualisation.

I have tried other alternatives for calculating the Unit using calculated columns but it also did not work.

Now I am out of options.

Here is the DAX for calculating the measure for Unit:

      • Unit =
      • SWITCH(
        • TRUE,
        • SELECTEDVALUE('Filter Selection Calculation Type'[SelectedID])= 2  && SELECTEDVALUE(DimImmoKategorie[ImmoKatID])= 1 ,
        • "CHF/m2 p.a",
        • DimEinheiten[EinheitName]
      • )

Any suggestions on how to make it work or what the issue can be?

Thank you for your guidance.

2 REPLIES 2
v-jingzhang
Community Support
Community Support

Hi @MKAS 

 

If you put only one measure in Values of a matrix, the "Show on rows" feature will not work. It works when you put multiple measures or fields in Values. Then the result of these fields will be displayed on rows instead of columns.

 

Regards,
Community Support Team _ Jing
If this post helps, please Accept it as the solution to help other members find it.

vanessafvg
Super User I
Super User I

Its hard to evaluate the problem without some data.  Can you please share more information?  Providing a pbix or dummy data will be useful in helping you to resolve the issue.





Did I answer your question? Mark my post as a solution!

Proud to be a Super User!




Helpful resources

Announcements
PBI_User Group Leader_768x460.jpg

Manage your user group events

Check out the News & Announcements to learn more.

Get Ready for Power BI Dev Camp

Microsoft named a Leader in The Forrester Wave

Microsoft received the highest score of any vendor in both the strategy and current offering categories.

Get Ready for Power BI Dev Camp

Power BI Dev Camp - September 30th, 2021

Mark your calendars and join us for our next Power BI Dev Camp!

PowerPlatform 768x460.png

Microsoft Learn

Check out our new Discover Your Career Path blog post series and get all the details.

Top Solution Authors