Forum Discussion

VizualByK's avatar
VizualByK
Regular Visitor
2 years ago
Solved

Disconnected Table Slicer

Hi all,   I have 2 disconnected tables. I am taking data from one of the tables and a slicer (Patient Copay) from another. Now I need to filter grids based on the slicer. To do that Ia m creating a...
Need Help
Show and Tell
  • Anonymous's avatar
    Anonymous
    2 years ago

    Hi VizualByK ,
    You can try the measure below

    IsFiltered = 
VAR _group = 
SWITCH(
    TRUE(),
    MAX('Copay Table'[Total Copay])<=3000, "$0-$3000",
    MAX('Copay Table'[Total Copay])>3000 && MAX('Copay Table'[Total Copay])<=5000, "$3000-$5000",
    MAX('Copay Table'[Total Copay])>5000 && MAX('Copay Table'[Total Copay])<=7500, "$5000-$7500",
    MAX('Copay Table'[Total Copay])>7500 && MAX('Copay Table'[Total Copay])<=10000, "$7500-$10000",
    MAX('Copay Table'[Total Copay])>10000 && MAX('Copay Table'[Total Copay])<=12500, "$10000-$12500",
    MAX('Copay Table'[Total Copay])>12500, "Above $12500"
)
RETURN
IF(
    _group IN VALUES('Patient Copay Amount'[Patient Copay]),
    1,
    0
)

    Final output

     

    Best regards,
    Albert He

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly

     

Anonymous's avatar
Anonymous
Not applicable
2 years ago

Hi VizualByK ,
You can try the measure below

IsFiltered = 
VAR _group = 
SWITCH(
    TRUE(),
    MAX('Copay Table'[Total Copay])<=3000, "$0-$3000",
    MAX('Copay Table'[Total Copay])>3000 && MAX('Copay Table'[Total Copay])<=5000, "$3000-$5000",
    MAX('Copay Table'[Total Copay])>5000 && MAX('Copay Table'[Total Copay])<=7500, "$5000-$7500",
    MAX('Copay Table'[Total Copay])>7500 && MAX('Copay Table'[Total Copay])<=10000, "$7500-$10000",
    MAX('Copay Table'[Total Copay])>10000 && MAX('Copay Table'[Total Copay])<=12500, "$10000-$12500",
    MAX('Copay Table'[Total Copay])>12500, "Above $12500"
)
RETURN
IF(
    _group IN VALUES('Patient Copay Amount'[Patient Copay]),
    1,
    0
)

Final output

 

Best regards,
Albert He

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly