Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

Using Visual Slicers in calculations

Hi,

 

Is there a way to 'use' visual slicers to update the value in created measures on the fly?

 

For example, I have created a table using the following DAX:  

 

Deductible =

GENERATESERIES (
MIN ( ClaimData[TotalDeductible] ), MAX ( ClaimData[TotalDeductible] ), 5 )
 
I then created a slicer visual using this tables value.  I would now like to use the value the user has identified from the slicer in a created measure.  Here is an image for a better representation of what I'm talking about:
 
Is there a way to 'use' the slicers value of $5,515 in a measure?  For example...given the three slicer values of Coinsurance = $15,990, Copay = $80 and Deductible = $5,515...is there DAX that supports something like:
 
Calculated value = Deductible[Value] + Copay[Value] + Coinsurance[Value]?
 
That way I could create a measure of have it calculate on the fly depending on the users input with the three slicer visuals.
 
 
 
 
Thank you!
Need Help
  • parry2k's avatar
    parry2k
    5 years ago

    Anonymous not sure if I understood the question but you can simply create measure and use these selected values in the slicers:

     

    Calculated value Measure = 
SELECTEDVALUE(Deductible[Value]) + 
SELECTEDVALUE(Copay[Value]) + 
SELECTEDVALUE(Coinsurance[Value])

     

    Check my latest blog post Comparing Selected Client With Other Top N Clients | PeryTUS  I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos to whoever helped to solve your problem. It is a token of appreciation!

    ⚡Visit us at https://perytus.com, your one-stop-shop for Power BI-related projects/training/consultancy.⚡

1 Reply

  • parry2k's avatar
    parry2k
    Super User
    5 years ago

    Anonymous not sure if I understood the question but you can simply create measure and use these selected values in the slicers:

     

    Calculated value Measure = 
SELECTEDVALUE(Deductible[Value]) + 
SELECTEDVALUE(Copay[Value]) + 
SELECTEDVALUE(Coinsurance[Value])

     

    Check my latest blog post Comparing Selected Client With Other Top N Clients | PeryTUS  I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos to whoever helped to solve your problem. It is a token of appreciation!

    ⚡Visit us at https://perytus.com, your one-stop-shop for Power BI-related projects/training/consultancy.⚡