Help converting column DAX to a measure to use SelectedValue()

[xxxvii]

I've created a donut chart using the following column DAX:

is_EOSL = 
IF(ISBLANK(RELATED('model'[eosl_date])), "Unknown",
    IF(
        RELATED('model'[eosl_date]) > TODAY(),
        "No", "Yes"
    )
)

It works great when I use today's date hardcoded as TODAY(). However, I'd like to make that date dynamic (using SelectedValue()) where it would use a date selected in a slicer. My problem is that, the slicer will only work as intended on a measure.

Any ideas on how I could convert the above code to a measure as a first step to accomplishing my end goal? 

[parry2k]

@xxxvii Yes, you cannot use measures in the legend. Check this video on my channel and tweak the solution to fit your needs: Mastering Disconnected Tables - Use measures in slicers in Power BI | PeryTUS - Power BI How To - Yo...

[parry2k]

@xxxvii very hard to tell without knowing the model and how you want to visualize it, but try this

is_EOSL Measure = 
VAR __eos1_Date = MAX ( 'model'[eosl_date] )
VAR __SelectedDate = SELECTEDVALUE ( 'DateSlicer'[Date] )
RETURN
IF(ISBLANK(__eos1_Date ), "Unknown",
    IF(
        __eos1_Date  > __SelectedDate,
        "No", "Yes"
    )
)

[xxxvii]

To convert the column to a measure, I actually had to create three seperate measures. Then I proceeded to adding all three measures to the Values section of my donut chart. That did the trick.

is_EOSL_NO = 
CALCULATE ( 
    COUNTROWS ( 'hardware_asset' ),
    NOT(ISBLANK('model'[eosl_date])) && 'model'[eosl_date] > TODAY()
)

is_EOSL_UNKNOWN = 
CALCULATE ( 
    COUNTROWS ( 'hardware_asset' ),
    ISBLANK('model'[eosl_date])
)

is_EOSL_YES = 
CALCULATE ( 
    COUNTROWS ( 'hardware_asset' ),
    NOT(ISBLANK('model'[eosl_date])) && 'model'[eosl_date] <= TODAY()
)

[xxxvii]

Good point. This is what the visual looks like right now using the calculated column. And the visualisation's properties. In the Legend, Status is the is_EOSL column that I referenced in my initial post. In the Values, Count of hardware_asset['asset_id'] is a count of asset_id from the fact table.

I was able to create the new measure using your code. The problem I'm facing now is, how to use the measure in my existing visual instead of the calculated column. I tried dragging the measure to Legend or Values in the visualization's properties, but it won't let me.