Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Greetings,
I am using the same measure in a card and in a matrix table. But both have different values. Can you sugest what could be the
problem. Same and only filter has been applied.
Kind Regards,
Hitesh N R
A measure is a global formula that calculates locally. The different result means that the evaluation context is different in those two visuals. It looks like one has an added filter on that visual.
Regards,
Pat
To learn more about Power BI, follow me on Twitter or subscribe on YouTube.
Hi, Thank you for reverting back.
The same filter has been applied in both cases ..some text went below the image so it may have gone unnoticed.
Hi @Anonymous ,
Based on your screenshots,the 2 filters have different filter conditions,one is >=101,and the other one is >=101&&<=100000,maybe it's the reason that causes the different output.
Best Regards,
Kelly
Did I answer your question? Mark my post as a solution!
Hi @Anonymous ,
If possible,would you pls upload your .pbix file to onedrive business and share the link with us?We need a test.
Remember to remove the confidential information.
Best Regards,
Kelly
Did I answer your question? Mark my post as a solution!
Dear Kelly, it will be difficult to share due to confidential nature. But let me try to seek permissions for the same abd will revert back if it is possible.
Kind Regards,
Hitesh
Hi @Anonymous ,
Below is a similar thread which may help.
Best Regards,
Kelly
Did I answer your question? Mark my post as a solution!
Hello @v-kelly-msft the totals are still different in the matrix and the card, i tried to include the only measure of interest in the matrix view to confirm the same
Hi @Anonymous ,
Hard to say,I made a simple sample to reproduce your senario,but failed.
I got the same totals based on the same measure with the same filters.
So if possible ,could you pls upload your .pbix file to onedrive business and share the link with us?
Remember to remove the confidential information.
Best Regards,
Kelly
Did I answer your question? Mark my post as a solution!
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
113 | |
97 | |
84 | |
67 | |
60 |
User | Count |
---|---|
150 | |
120 | |
99 | |
87 | |
68 |