>= Target with context of current FY

[Tob_P]

Hi,

Stumped on this one. I have a Target for a number of stores - sales obviously count towards the target for the current FY. I have a measure with % to Target [% to Target] and another measure [Projection] which calculates a % above or below target based on the current years sales.

I need to count the number of stores that are likely to exceed that target in the FY....so [Projection] >= 1 or 100%

First thing that came to mind was a calculated column based on an If statement >= 1, "On Target", "Behind Target", then realised that wouldn't take into account the context of the FY.

So clearly need to do this in a measure and have tried ISCROSSFILTERED, ALLCROSSFILTERED but with no luck.

Anyone able to point me in the direction of where I should be looking with this - seems a fairly straight forward thing to calculate! Thanks

[v-zhangti]

Hi, @Tob_P 

Can you provide sample data for testing? Sensitive information can be removed in advance. What kind of expected results do you expect? You can also show it with pictures or Excel. 

Best Regards,

Community Support Team _Charlotte

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Tob_P]

Have tried something along the lines of this...

DAX =

VAR Projection =

IF([Projection] >=1, 1)

VAR Stores =

[No of Stores]

VAR Result =

(Stores * Projection)

RETURN

Result

...but returns a blank result