Forum Discussion

Gusd8's avatar
Gusd8
Helper I
1 year ago
Solved

Interactive Visual and Measure...utilizing tooltips

Thank you for looking I have a table that has a list of questions and then a pass/fail column I created a measure (Total) that does a countrow to get the total number of questions, a second measure...
Need Help
  • Akash_Varuna's avatar
    Akash_Varuna
    1 year ago

    Hi Gusd8 It might be because the filter from the pie chart is affecting the Passrate calculation in the line chart.
    Could you please try modifying your measure something like this

    Passrate = 
DIVIDE(
    CALCULATE([Pass], REMOVEFILTERS('Table'[Pass/Fail])),
    [Total]
)

     

Akash_Varuna's avatar
Akash_Varuna
Super User
1 year ago

Hi Gusd8 It might be because the filter from the pie chart is affecting the Passrate calculation in the line chart.
Could you please try modifying your measure something like this

Passrate = 
DIVIDE(
    CALCULATE([Pass], REMOVEFILTERS('Table'[Pass/Fail])),
    [Total]
)