Matrix help

[ranaji77]

I am trying to recreate an SSRS Matrix in Power BI.

You can see below (SSRS result exported to excel) I have Persons' name, Total No. of Suites by person and Sq. Ft. (sum of sq. ft.) as columns and then Pivoted categorie with values, there is a drill down that gives you suite level detail which you can see for Not Assigned:

I am trying to recreate it in Power BI, I am not getting the same visual:

 - Total No. of Suites which is basically a count of all suites under each person, shows for each category if I put it as a Value, I want to show just 1 column for Total No. of Suites and not summzarize it for each category, same goes for Sq. Ft.

This is a Stepped Layout, so that is not solving the issue.

Any help appretiated.

Thanks

[v-lid-msft]

Hi @ranaji77 ,

We can try to show the suits number only in the grand total as a workaround, and hide the value when it does not blank by reducing the width size.  Blank() is used to prevent eight from  increasing  when reduce the widthe.

SutisMeasure = IF(ISINSCOPE('Table'[ProdCategDesc]),BLANK(),SUM('Table'[Suits]))

Best regards,

[ranaji77]

I will give it a try, not sure if thats what i want but i will see how it looks visually and obviously numbers wise.

Thanks

[v-lid-msft]

Hi @ranaji77 ,

How about the result after you follow the suggestions mentioned in my original post?Could you please provide more details about it If it doesn't meet your requirement?

Best regards,

[ranaji77]

management didnt like the idea, so we will keep this report in SSRS for now.