Forum Discussion

Pallavi's avatar
Pallavi
Icon for Helper II rankHelper II
9 years ago

How to get values under particular row in Matrix Table

SSRSPower BI

Li 6iv balance quarter level displayed only for Borough Level as seen in SSRS Report i.e rest of the values are blank. While adding in PowerBI i am finding a problem to restrict the value for Borough Level  the values are getting displayed on each row and summing up the total which gives wrong value. Please help me

Need Help

6 Replies

    • Pallavi's avatar
      Pallavi
      Icon for Helper II rankHelper II
      9 years ago

      Thanks for your reply.Could you be more descriptive.

       

      Regards

  • v-huizhn-msft's avatar
    v-huizhn-msft
    Icon for Microsoft Employee rankMicrosoft Employee
    9 years ago

    Hi Pallavi,

    How did you calculate the total? How to get 541? And in Power BI martix, "min of Li 6iv balance quarter level" is a measure, could you please share your resource table, and more details for further analysis?

    Best Regards,
    Angelia

    • Pallavi's avatar
      Pallavi
      Icon for Helper II rankHelper II
      9 years ago

      Hi Angela,

       

      Value 541 stored under LI 6iv Balance column comes from a table directly, populating the same value in SSRS. In PowerBI , how can i restrict it to Borough Level

       

      Regards

  • Pallavi's avatar
    Pallavi
    Icon for Helper II rankHelper II
    9 years ago

    Thanks much for sharing the link. I went through but felt this is not related to my question though i am not sure. In my table all values are empty for Li 6iv balance column at station Level and WatchName Level and the value exists only at borough level under Total. How can i display the value in Total row at Borough Level considering rest of the values are empty.

     

    Link provided says there are certain values for every year , based on the condition it is summing up the values and giving the result.

    Suppose consider the same case , year1, year2...,year5 values are empty , there is a total column which gives a direct value of 5000. How can i display 5000 in Total row.

     

    Regards

    • v-huizhn-msft's avatar
      v-huizhn-msft
      Icon for Microsoft Employee rankMicrosoft Employee
      9 years ago

      Hi Pallavi,

      I am still confusing, the 541 is not calculated from the rows above, come from a table directly. And I am not specific about SSAS, you'd better share your sample table. I totally understand your data is private, you can create same fake data like yours, then post the expected result. So that we can post solution which is close to your requirement.

      In addition, total row value is always based on the calculation of rows above.

      Best Regards,
      Angelia