Forum Discussion

taylorb's avatar
taylorb
Helper I
5 years ago

Measure Using SWITCH Not Applying Filters to Underlying Measures

I am trying to minimize the number of measures I am using in a dashboard. I ended up creating several that are nearly identical so I thought I could use some IF statements to reduce the amount of mea...
Need Help
amitchandak's avatar
amitchandak
Super User
5 years ago

taylorb , if it is a measure then it should be like this assuming all other are measures too

 

Avg Rate = 
SWITCH(max('Summary Cards'[Line of Business]),
    "External", [!ExternalAvgRates],
    "Internal", [!InteralAvgRates],
    "Interdepartmental", [!InterdeptAvgRates],
    "New Hire", [!NewHireAvgRates],
    "Tenured", [!TenuredAvgRates],
    )

 

  • taylorb's avatar
    taylorb
    Helper I
    5 years ago

    Sorry, I made a mistake in my original post (I have corrected it). The SWITCH is in a calculated column not a measure. Sorry for the confusion

    • taylorb's avatar
      taylorb
      Helper I
      5 years ago

      I think I answered my own question... obviously a calculated column wont take a filter into its calculation.