Forum Discussion
Resolver IIAdding a measure to a table visual eliminates rows
Hi yasbos
Reduding of rows happens because of filter context.It works with the same logic as pivot at Excel.
I suppose that your measure has some aggregation effect / for some rows that return no value.
There are a few steps you can apply to see all rows (my be just one of them)
1. Select the option of "don't summarize " for your categorical columns
2. To check on the option "Show values with no data"3. add "+0" to your measure.
Unfortunately, I am out of the limit of pictures that I can add to the discussions so I put the screenshots to PowerPoint you can download them from here: Link to the file
If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly
Super UserHi yasbos
Reduding of rows happens because of filter context.
It works with the same logic as pivot at Excel.
I suppose that your measure has some aggregation effect / for some rows that return no value.
There are a few steps you can apply to see all rows (my be just one of them)
1. Select the option of "don't summarize " for your categorical columns
2. To check on the option "Show values with no data"
3. add "+0" to your measure.
Unfortunately, I am out of the limit of pictures that I can add to the discussions so I put the screenshots to PowerPoint you can download them from here: Link to the file
If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly
yasbosThanks so much, Ritaf1983 you are awesome. That's all that I needed. I just needed some validation that this is normal and what type of circumstances can cause it. Now, I can review my measure (which does have aggregations, indeed) in light of your insights. Thanks again.
- Ritaf1983
Happy to help 🙂