Forum Discussion

jonnyA's avatar
jonnyA
Icon for Responsive Resident rankResponsive Resident
3 years ago

Need help Updating a working formula

I have the following formula which works, (but i need to add a 3rd option) ↓

 

State Medicare Mix Test = CALCULATE([Visits],FILTER(vw_Demo_Charge_Dataset_BP, or( vw_Demo_Charge_Dataset_BP[Insurance_Type] = "HMO Medicare", vw_Demo_Charge_Dataset_BP[Insurance_Type] = "Medicare", vw_UHC_Charge_Dataset_BP[Insurance_Type] = "Medicare")))
 
But I also need to include "USA State Plan" as a 3rd option.
 
Can anyone help me on completing the formula?
 
Does it have something to do with the OR (Highlighted yellow)
 
Thanks in advance!
Need Help

2 Replies

  • Ahmedx's avatar
    Ahmedx
    Icon for Super User rankSuper User
    3 years ago

    pls tru this

     

     

    State Medicare Mix Test =
CALCULATE(
    [Visits],
vw_Demo_Charge_Dataset_BP[Insurance_Type] 
              in { "HMO Medicare", "Medicare","Medicare","USA State Plan"}
)

     

     

  • Anonymous's avatar
    Anonymous
    Not applicable
    3 years ago

    State Medicare Mix Test = CALCULATE([Visits],  vw_Demo_Charge_Dataset_BP[Insurance_Type] IN {"HMO Medicare", "Medicare", "USA State Plan"})