Subtotal by merged rows is repeating, but I only want to show one.

[JoyceWW]

Hello, I am wondering why does my merged rows show repeated values when I ask for a row subtotal ? I have not created any relationship in here. Can someone please advise? Thank you so much! 

[Ritaf1983 · Accepted solution]

Hi @JoyceWW you have subtotal for every level in the hierarchy.

You can manipulate which of them you want to show from here :

If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly

[Ritaf1983 · Accepted solution]

Hi @JoyceWW you have subtotal for every level in the hierarchy.

You can manipulate which of them you want to show from here :

If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly

[JoyceWW]

Hello Rita, I have tried it, but it still shows a lot of total amounts, instead of only 1. 

[Ritaf1983 · Accepted solution]

Hi  
Refer to the linked tutorial. 
https://www.youtube.com/watch?v=UyJieY69_sE

Or share a link to the dummy pbix.

If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly

@JoyceWW