Forum Discussion

rock4sridhar's avatar
rock4sridhar
Regular Visitor
7 years ago
Solved

Dynamic Measure depends on slicer value

Hi,

 Need help in building a pie chart where the data is as follows,

 

col1 col2

A      150

B       500

C       200

 

when we click "A" on the slicer,the pie chart should display A (% out of 100) and remaining percentage should be B+C(%) should be displayed.can anyone help me in this scenario

Need Help
  • hnguy71's avatar
    hnguy71
    7 years ago
    Basic Percentage Formula = 
var Numerator = LOOKUPVALUE(Table1[Column2], Table1[Column1], SELECTEDVALUE(Table1[Column1]))
var Denominator = CALCULATE(SUM(Table1[Column2]), ALLEXCEPT(Table1, Table1[Column2]))
return
DIVIDE(Numerator, Denominator)
  • hnguy71's avatar
    hnguy71
    7 years ago

    Sorry for the late response,

     

    If you click your visual and click Format > Edit Interactions. Some new options should appear on your visual. What you want to do is change it to HIGHLIGHTING mode.

     

     

    Hope that helps

6 Replies

    • hnguy71's avatar
      hnguy71
      Super User
      7 years ago
      Basic Percentage Formula = 
var Numerator = LOOKUPVALUE(Table1[Column2], Table1[Column1], SELECTEDVALUE(Table1[Column1]))
var Denominator = CALCULATE(SUM(Table1[Column2]), ALLEXCEPT(Table1, Table1[Column2]))
return
DIVIDE(Numerator, Denominator)
      • rock4sridhar's avatar
        rock4sridhar
        Regular Visitor
        7 years ago

        Hi i have tried the above formula but its not working though... :(