cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Helper III
Helper III

Same Measure used in 2 places, but shows different values

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 TotalCoursesDifferent Values.png

 

problem. Same and only filter has been applied.

 

Kind Regards,

Hitesh N R 

9 REPLIES 9
Super User IV
Super User IV

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





Did I answer your question? Mark my post as a solution! Kudos are also appreciated!

To learn more about Power BI, follow me on Twitter or subscribe on YouTube.


@mahoneypa HoosierBI 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.error007.png

Hi  @Hitesh1604 ,

 

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!

revert.png

Hi @Hitesh1604 ,

 

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  @Hitesh1604 ,

 

Below is a similar thread which may help.

 

https://community.powerbi.com/t5/Desktop/Same-Measure-showing-different-values-on-different-visualiz...

 

 

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  @Hitesh1604 ,

 

Hard to say,I made a simple sample to reproduce your senario,but failed.

v-kelly-msft_0-1607411931673.pngv-kelly-msft_1-1607411953252.png

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!

 

Helpful resources

Announcements
secondImage

Congratulations!

We are excited to announce the Power BI Super Users!

Microsoft Ignite

Microsoft Ignite with Arun Ulag

Featured Session Drive Data Culture with Power BI: Vision, Strategy & Roadmap. Register here https://myignite.microsoft.com #MSIgnite #PowerPlatform #Power BI ​

Microsoft Ignite

Microsoft Ignite

Join digitally, March 2–4, 2021 to explore new tech that's ready to implement. Experience the keynote in mixed reality through AltspaceVR!

secondImage

The largest Power BI virtual conference

100+ sessions, 100+ speakers, Product managers, MVPs, and experts. All about Power BI. Attend online or watch the recordings.

Top Solution Authors
Top Kudoed Authors