CODEWITHSUNDEEP
powerbidax
Andy Williams
Andy Williams

Reputation: 907

Power BI: Measure is not ignoring Slicer Filter

My Dax Query is correctly bringing back the expected data. The one caveat, I can't seem to ignore an outside slicer to the visual for this one particular calculation. What am I doing wrong?

xxPY_TrafficSum = CALCULATE (
    [xPY_TrafficSum],
    DATESBETWEEN (
        DimDate[FullDate],
        DATE (
            YEAR ( ALLSELECTED ( DimDate[FullDate] ) ) - 2,
            MONTH ( ALLSELECTED ( DimDate[FullDate] ) ),
            DAY ( ALLSELECTED ( DimDate[FullDate] ) ) + 1
        ),
        DATE (
            YEAR ( ALLSELECTED ( DimDate[FullDate] ) ) - 1,
            MONTH ( ALLSELECTED ( DimDate[FullDate] ) ),
            DAY ( ALLSELECTED ( DimDate[FullDate] ) ) + 1
        )
    ),
    ALL ( DimDate[IsLastDayOfMonth], DimDate[IsLastDayOfMonth] )
)

enter image description here

Upvotes: 0

Views: 272

Answers (1)

CR7SMS
CR7SMS

Reputation: 2584

I don't think you have to specify the column twice within the ALL function. Although I am not sure how this would affect the calculation, you can give it a try:

All(DimDate[IsLastDayOfMonth])

One more thing you could try is to move the position of the ALL function within the calculation. i.e) switch the positions of the DATESBETWEEN and the ALL functions. If your issue is still not resolved, it would be great if you can share a sample data/file for us to look at.

Upvotes: 0

Related Questions