Show Text for no data - Dax

Anonymous Not sure if it will help but here:

Any chance you can share sample data as text so that I can mock this up?

Hi Anonymous 

When a measure is forced to display something other than its actual value when blank, the formula engine performs a full cross-join of the dimension tables in the visual, evaluating each row explicitly. This can result in unexpected data points appearing. For example, a previously removed ID (e.g., one terminated in 2013) may still appear for a selected period, such as late February, but with custom values. That's why you're seeing RDO for those that are not within the slicer selection. You can add a condition to your measure to show only when a date is within the selected range. 

VAR MinDate =
    CALCULATE ( MIN ( 'calendar'[date] ), ALLSELECTED ( 'calendar' ) )
VAR MaxDate =
    CALCULATE ( MAX ( 'calendar'[date] ), ALLSELECTED ( 'calendar' ) )
RETURN
    IF (
        SELECTEDVALUE ( 'calendar'[date] ) >= MinDate
            && SELECTEDVALUE ( 'calendar'[date] ) <= MinDate,
        [rdo measure]
    )