Forum Discussion
Table visual showing different total compared to mesaure when a single record is selected
So i have this table showing 2 measures that calculates percentile 25 and percentile 95. When i have a single record selected the total is not showing the same as the measure
My question not aimed that fixing this error, but related to why this is happening.
So does anyone know why the measure and total is off?
Is there a different filter context going in the total compared to the measure?
3 Replies
Ratax it is a million-dollar question and it is DAX fundamentals. At row-level, your row filter is passed to filter context, in this case, chemistry batch value but at the total level, it is not happening, and that's;s why you are seeing the different results. To deep dive into this, you need to understand the DAX concepts of row context, context transition to filter context.
✨ Follow us on LinkedIn and to our YouTube channel
I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos to whoever helped to solve your problem. It is a token of appreciation!
⚡ Visit us at https://perytus.com, your one-stop shop for Power BI-related projects/training/consultancy.
parry2k Thanks for your reply.
From my understanding the row filter is passed to the filter context when the Calculate function is used.
i attached this screendump.
From what i can see the Total on the table visual is showing the correct value where the row filter is passed to the filter context.
it's the row in the table this is showing the wrong value.
Statement:
The row filter is passed to the filter context in the total of the table.
In the row is the table the row filter is not passed to the filter context.
Is this statement correct?
Hi Ratax ,
Have your problem been solved, if yes, you could share your solution so that others can find the solution.
If no, can you share your DAX expression of P25 Raw? Or the pbix file without sensitive data and I will check it.
Best Regards
Community Support Team _ chenwu zhu
