Blocking the impact of filters on a measure

[EladAppelNN]

Hi

Need help with filters applied to DAX

When the filter version "Actual" is selected the fomula below works, it returns that last date of actual sales reported

LastActMonth = CALCULATE(max ('fact Sales'[Calendar Day]),'fact Sales'[Version]="Actual")

But I must have it working also when the Budget Version is selected in the filter visual

Appreciate help on this

kr, Elad

[Uzi2019]

Hi @EladAppelNN ,
Try using the below calcultion. I just modified your calculation a little bit.

If I answered your question please give kudos and accept it as a solution!
Thanks

[Anonymous · Accepted solution]

Hi  @EladAppelNN ,

You can use the following DAX:

Measure =
MAXX(
 ALLSELECTED('fact Sales'),[Calendar Day])

The Allselected() function calculates based on the data you filter on visual

Refer to:

ALLSELECTED function (DAX) - DAX | Microsoft Learn

If the results don't meet your expectations, can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data. We can better understand the problem and help you

Best Regards,

Liu Yang

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

[Ritaf1983]

Hi @EladAppelNN 

Please provide sample data that covers your issue or question completely, in a usable format (not as a screenshot).
https://community.powerbi.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-Forum/ba-...
Please show the expected outcome based on the sample data you provided.

https://community.powerbi.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447523