Forum Discussion

ranaji77's avatar
ranaji77
Regular Visitor
6 years ago

Matrix help

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

 

Need Help

4 Replies

  • v-lid-msft's avatar
    v-lid-msft
    Community Support
    6 years ago

    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's avatar
      ranaji77
      Regular Visitor
      6 years ago

      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's avatar
        v-lid-msft
        Community Support
        6 years ago

        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,