Forum Discussion

Pallavi's avatar
Pallavi
Helper II
9 years ago

How to get values under particular row in Matrix Table

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 f...
Need Help
Pallavi's avatar
Pallavi
Helper 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
    Microsoft 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