Forum Discussion

JSebastianBN's avatar
JSebastianBN
Regular Visitor
7 months ago
Solved

Rows without data showing subtotals

Hi, below you can see my example (below the data): The column "Sum of SP" has values at row values F and it computes the subtotals at row C levels and E levels. The column "Sum of STSP" only ...
Need Help
  • ryan_mayu's avatar
    ryan_mayu
    7 months ago

    JSebastianBN 

    You are welcome.

     

    If you want to compare STSP with SP, maybe you can remove the third level, since the comparison at that level is meaningless.


    If my solution works, please accept it and appreciate your kudos as well.

     

cengizhanarslan's avatar
cengizhanarslan
Icon for Super User rankSuper User
7 months ago

Looks like you have some problem within your relations in your model. You could use a measure like below as an example but I think it won't be a perfect solution here. It would be the best if you share a .pbix example.

 

STSP =
IF (
    ISINSCOPE ( 'Dim'[C] ) || ISINSCOPE ( 'Dim'[F] ),
    BLANK(),
    [Sum of STSP]
)
JSebastianBN's avatar
JSebastianBN
Regular Visitor
7 months ago

Hi, I just added the data to the post. Thanks!