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.

  • eaweyepe01's avatar
    eaweyepe01
    Regular Visitor
    5 years ago

    Thanks amitchandak,

    It is working partially , it shows all customers and returns Avg Sales only for selected Top N and for the rest of customers its blank. Is there a way I can code so I dont see the remaining customers in my table?

    Thanks