NOT ABLE TO USE SWITCH OVER CATEGORICAL STRING VALUE .

[Anonymous]

HI Guys 

I have preapred a measure to calculate rolling last 30 days average 

Averageoflast30dayspeakdayoffpeakhour =

VAR tday= LASTDATE('KPI TABLE'[DATE])

VAR tday_2 = tday-1

return

CALCULATE(AVERAGE('KPI TABLE'[COMPLETED_ORD_COUNT]),ALLEXCEPT('KPI TABLE','KPI TABLE'[BUSINESS_SERVICE],'KPI TABLE'[DIMENSION],'KPI TABLE'[DATE]),DATESINPERIOD('KPI TABLE'[DATE],tday_2,-30,DAY))

I have two column in my table 1. measuring method  2. comparsion period 

currently the measure that i  have prepared so far is for only one scenario like measuring method = Average and comparsion period = last 30 days 

i have to use same measure depending on the  various combination of above mentioned two columns 

I want measure something like 

case when measuring_method= "average" and comparsion_period= last 30 days then calculation1

case when measuring_method= "maximum" and comparsion_period= last 30 days then calculation2

PLease help me !!!!!!

[v-lili6-msft · Accepted solution]

hi  @Anonymous 

You just drag measuring method  and comparsion period field into a visual, then create a measure as this and drag it into visual too:

Measure =
IF (
    SELECTEDVALUE ( 'Table1'[measuring_method] ) = "average"
        && SELECTEDVALUE ( 'Table1'[comparsion_period] ) = "last 30 days",
    [calculation1],
    IF (
        SELECTEDVALUE ( 'Table1'[measuring_method] ) = "maximum"
            && SELECTEDVALUE ( 'Table1'[comparsion_period] ) = "last 30 days",
        [calculation2]
    )
)

Regards,

Lin

[Anonymous]

Thanks I will let you know soon 

[amitchandak]

@Anonymous , this is a good example of switching. Look at method that has been used

https://community.powerbi.com/t5/Desktop/Slicer-MTD-QTD-YTD-to-filter-dates-using-the-slicer/td-p/500115

Also, refer https://powerpivotpro.com/2013/03/hasonevalue-vs-isfiltered-vs-hasonefilter/

[Anonymous]

Thanks I will check and will let you know