Different measure calculations based on Slicer selection

[Himanshu_1306]

Hi All,

I have a situation where I want to use two seperate calculations in a single measure while using the Slicer. 
While selecting the fiscal quarter as Q4(Current) I want to show the pacing using the below calculation

SQO QTD $ Pacing_V2 = DIVIDE([SQO QTD $(Pacing)],[SQO $ QTD Target(Pacing)],0)

whereas if user select any other quarter ( which is not current ) I want to use calculation as below

SQO $ QTD Attainment = DIVIDE([SQO $ QTD],[SQO $ FQ Target_G],0)

How should I achieve this scenario?

Regards,

[PaulDBrown]

Sorry, I'm not following your scenario.. can you provide a sample PBIX file?

[Himanshu_1306]

I was able to create a measure to make it work dynamically and got the desired result.

Thank you !!!

[PaulDBrown · Accepted solution]

If you add a column in your date table to flag the current FY Quarter (say using a 1 as a flag -let's call this 'Date Table'[FYQ Flag]- , you can then use a simple if clause in the measure to switch calculations:

Selection measure =
IF (
    MAX ( 'Date Table'[FYQ Flag] ) = 1,
    DIVIDE ( [SQO QTD $(Pacing)], [SQO $ QTD Target(Pacing)], 0 ),
    DIVIDE ( [SQO $ QTD], [SQO $ FQ Target_G], 0 )
)

(Instead of the flag in the date table you could write the code to establish the current FYQ in a VAR within the measure of course...)

[Himanshu_1306]

@PaulDBrown Thanks for the update.

I'm able to achieve the desired result using the below measure but is there a way to make it dynamic because currenty I will have to change the value of my variable (_CFQ) each quarter .

Also I dont have a flag value as 1 as you mentioned but I do have a column "Rolling Fiscal Quarter" which shows the latest quarter when its 0 so Rolling Fiscal Quarter = 0 will show the latest quarter.

Can we use this to make it dynamic?

Measure:

Selection measure =

VAR _CFQ = CALCULATE(MAX(F_SQO_TARGETS[FISCAL_YEAR_QUARTER]),F_SQO_TARGETS[Current Fiscal year and quarter] = TRUE())

RETURN

IF (

    _CFQ = "FY24 Q4",

    DIVIDE ( [SQO QTD $(Pacing)], [SQO $ QTD Target(Pacing)], 0 ),

    DIVIDE ( [SQO $ QTD], [SQO $ FQ Target_G], 0 )

)