Same Measure used in 2 places, but shows different values

[Anonymous]

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 

[mahoneypat]

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

[Anonymous]

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.

[v-kelly-msft]

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!

[Anonymous]

[v-kelly-msft]

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!

[Anonymous]

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

[v-kelly-msft]

Hi  @Anonymous ,

Below is a similar thread which may help.

https://community.powerbi.com/t5/Desktop/Same-Measure-showing-different-values-on-different-visualization/td-p/475559

Best Regards,
Kelly

Did I answer your question? Mark my post as a solution!

[Anonymous]

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

[v-kelly-msft]

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!