Forum Discussion
Rows without data showing subtotals
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.
Super UserWe can use measure to show C as blank. However, it's better to find out the root cause.
could you pls provide the sample data , not the matrix visual
Hi, just added the data to the original post. Thanks!
- ryan_mayu
the data model is not very good. However, I am familiar to your business. So I can't tell you how to improve this.
To solve this problem, you can try to create a measure
Measure = if(ISFILTERED(Feature[Features]),blank(),sum(EpicSTSP[STSP]))pls see the attachment belowThanks for your help Ryan 🙂 Your proposal works.
I wonder however if this can be fixed somehow from the Model itself. I've a couple of questions:
1) Can this be solved from the Model itself? I do not understand why PowerBI should automatically fill cells where there is no value.
2) You mention that the model is not very good. Do you have recommendations that I can follow to improve it?
Hope you can help men. Thanks for your time!
- ryan_mayu
In most cases, we start our data aggregation from the lowest level.
e.g.
Level 1: A
Levle 2: A1,A2
A1=10,A2=20, then A = 10+20=30
However, in your scenario, the value is assigned to higher level and skipped the lower level.
Then, the bottom-level data automatically inherits the values from the higher-level.
That's not what we do usually. And like what I mentioned before, since I am not familar to your business, so I am sorry that I can't tell you where you can improve in this scenario.