Filter for a measure similar to a filter for visualization

[zenonsbelskiss]

Hello, PowerBI Gurus,

So I have a simple measure that computes a forecast for the selected period. When I use a card visualization and apply a filter to it it works just fine. However, if I need to use the measure in other calculations, then the filter which I applied to the card gets lost.

My question is: How do I incorporate the filter directly into the measure? (I need a filter that filters out just the chosen year)

Here is my measure:

Forecast 2019 = CALCULATE(SUM(MANAGERS[Plan 2019])/12, ALL())*DISTINCTCOUNT(SALES[Year-Month])

Thank you in advance,

PowerBI beginner.

[v-xicai]

Hi @zenonsbelskiss ,

You may change the measure like DAX below, which uses ALLSELECTED function to catch the filter.

Forecast 2019 =
CALCULATE ( SUM ( MANAGERS[Plan 2019] ) / 12, ALLSELECTED ( MANAGERS ) )
    * CALCULATE ( DISTINCTCOUNT ( SALES[Year-Month] ), ALLSELECTED ( SALES ) )

Best Regards,

Amy 

Community Support Team _ Amy

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

[Fowmy]

@zenonsbelskiss 

I don't have enough information about your model, try this measure if it can be used. I supposed you have Dates table

Forecast 2019 = 
VAR __YEAR = SELECTEDVALUE(DATES[Year]) RETURN
CALCULATE(
    SUM(MANAGERS[Plan 2019])/12, 
    DATES[Year] <> __YEAR
)
*
DISTINCTCOUNT(SALES[Year-Month])

________________________

If my answer was helpful, please consider Accept it as the solution to help the other members find it

Click on the Thumbs-Up icon if you like this reply 🙂

YouTube  LinkedIn