Forum Discussion

eaweyepe01's avatar
eaweyepe01
Regular Visitor
5 years ago
Solved

dynamic variance chart

Hi  Please I need a method to create a variance chart  showing the  first N customers(based on users input ) and  a dynamic variance = average sales - value . Value is a dynamic input from the users...
Need Help
  • Ashish_Mathur's avatar
    Ashish_Mathur
    5 years ago

    Hi,

    Modify the measure to

    Measure = if(ISBLANK([Top CX]),BLANK(),[Top CX]-SELECTEDVALUE('Price'[Price]))

    Hope this helps.

Ashish_Mathur's avatar
Ashish_Mathur
Super User
5 years ago

Hi,

Modify the measure to

Measure = if(ISBLANK([Top CX]),BLANK(),[Top CX]-SELECTEDVALUE('Price'[Price]))

Hope this helps.