Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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
Regards,
Solved! Go to 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...)
Proud to be a Super User!
Paul on Linkedin.
Sorry, I'm not following your scenario.. can you provide a sample PBIX file?
Proud to be a Super User!
Paul on Linkedin.
I was able to create a measure to make it work dynamically and got the desired result.
Thank you !!!
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...)
Proud to be a Super User!
Paul on Linkedin.
@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:
User | Count |
---|---|
96 | |
85 | |
77 | |
66 | |
63 |
User | Count |
---|---|
110 | |
95 | |
95 | |
64 | |
59 |