Forum Discussion

Majeebus's avatar
Majeebus
Frequent Visitor
3 years ago
Solved

Quick Measure-Difference from filtered value shows different totals depending on where placed

Hey guys, this is my first post here.  This forum has helped me a lot though.  I will start by saying I'm not a pro at this.  I like designing dashboards, and try to use only quick measures if I can ...
Need Help
  • Majeebus's avatar
    Majeebus
    3 years ago

    YES!!!!!!@!!  I FIGURED IT OUT!!!!!  

    So I took the original algorithm here:

    And added an additional calculation to the VAR_MEASURE_VALUE field here:

    This now shows the correct information!  Thanks!

v-xiaotang's avatar
v-xiaotang
Community Support
3 years ago

Hi Majeebus  

Thanks for reaching out to us.

>> So the wierd thing is that if I put the measure into any other field (like the column field, or if I change to a line graph and place in the main line field, or the tooltips) it shows me the correct answer which is the first %timely difference from 2021. 

I suspect this phenomenon is context related, please refer How To Apply Context Concept in DAX — DAX in Power BI — Chapter 3 | by Arpita Ghosh | Analytics Vidhya | Medium

 

Best Regards,

Community Support Team _Tang

If this post helps, please consider Accept it as the solution to help the other members find it more quickly.

Majeebus's avatar
Majeebus
Frequent Visitor
3 years ago

You have me pretty confused.  The article you listed shows context by adding a filter.  I already have the filter in the measure, and I would think it's an explicit filter.

Can you explain where you think the explicit context of the measure is incorrect?  The only place I would think I could add an additional explicit filter would be on the VAR_MEASURE_VALUE+[%Timely] line, but when I try that it breaks the algorithm.