Date slicer not working properly with Matrix (table filter working fine)

[IvanS]

Hi guys,

I have table with activities done/not done for our projects with column "Done" which contains values Yes/No. I have created matrix visual as per attached screenshot. There was request from business to populate value "n/a" for those activities that are not part of project - therefore I have created following measure.

Measure_Done = 
IF(MAX(RealizationFinalCheck[Done]) = "Yes", "Yes",
    IF(MAX(RealizationFinalCheck[Done]) = "No", "No",
    "n/a"
    )
)

If there is no date selected, measure is properly replacing blank values with "n/a". The problem starts when the date is selected (e.g. 2023). As shown on second screen, year in filter Date of "InOperation" is selected to 2023 however the projects without Date of "InOperation" are still visible and the Yes/No values are all replaced by "n/a". The replacement is due to measure - this is clear to me. 

However, if I select date filter in the filter panel on table visual and select year 2023, the table is filterred properly and projects without date of "InOperation" are removed from matrix.

Can you please guide me to the right direction how to enable filterring matrix via slicer?

Thank you
IvanS

[Anonymous · Accepted solution]

Hi @IvanS ,

Please have a try.

Measure_Done =
IF (
    HASONEVALUE ( 'Date'[Year] ),
    VAR SelectedYear =
        SELECTEDVALUE ( 'Date'[Year] )
    RETURN
        IF (
            MAX ( RealizationFinalCheck[Done] ) = "Yes"
                && MAX ( RealizationFinalCheck[Date of "InOperation"] ) = SelectedYear,
            "Yes",
            IF (
                MAX ( RealizationFinalCheck[Done] ) = "No"
                    && MAX ( RealizationFinalCheck[Date of "InOperation"] ) = SelectedYear,
                "No",
                "n/a"
            )
        ),
    BLANK ()
)

How to Get Your Question Answered Quickly 

If it does not help, please provide more details with your desired output and pbix file without privacy information (or some sample data) .

Best Regards
Community Support Team _ Rongtie

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

[amitchandak]

0 between range
Measure = var _1= if(IF(MAX(RealizationFinalCheck[Done]) = "Yes", "Yes",
IF(MAX(RealizationFinalCheck[Done]) = "No", "No",
"n/a"
)
))
var _year = maxx(ALLSELECTED('Calendar'), 'Calendar'[Year])
return
if(max('Calendar'[Year]) =_year , BLANK(), _1)

[IvanS]

Hi @amitchandak ,
I am having error in that function. Don't you miss "result if true" part?