Forum Discussion

HELPME_JFLO's avatar
HELPME_JFLO
New Member
3 years ago

Switch Formula on Multiple Selection on Slicer?

Hi All,    I have a what I think, a pretty simple model/ask I am asking of Power BI (I think), and still can't figure out what I'm doing wrong.    I have one fact table and a product line (catego...
tamerj1's avatar
tamerj1
Icon for Community Champion rankCommunity Champion
3 years ago

Hi HELPME_JFLO 

please try

=
SUMX (
VALUES ( 'Product Line Filter'[Lowest] ),
SWITCH (
'Product Line Filter'[Lowest],
"A", [9775 - SALES_GAL],
"B", [16034 - SALES_LBS_ETHYLENE]
)
)

HELPME_JFLO's avatar
HELPME_JFLO
New Member
3 years ago

Hey thanks for trying, but it still produced the same output unfortunately. 

  • tamerj1's avatar
    tamerj1
    Icon for Community Champion rankCommunity Champion
    3 years ago

    HELPME_JFLO 

    Can you please provide some screenshots?