"Current data and filters produce no result for this value" with text measure in textbox

[Denis_Zinukov]

Hello,

I encountered the following problem: in textbox the values of measure that return text return message: "Current data and filters produce no result for this value" in Power BI Desktop if I create calculated group item "YOY":

VAR ValueCurrentPeriod =
    SELECTEDMEASURE ()
VAR ValuePreviousPeriod =
    CALCULATE ( SELECTEDMEASURE (), 'Time Intelligence'[Time Intelligence] = "PY" )
VAR Result =
    IF (
        ISBLANK ( ValueCurrentPeriod ) && ISBLANK ( ValuePreviousPeriod ),
        ValueCurrentPeriod - ValuePreviousPeriod
    )
RETURN
    Result

If I delete this item or change to return varriable "ValueCurrentPeriod" text measure in textbox returt correct value.

Does any solutiuon?

Sample file

[DataInsights]

@Denis_Zinukov,

I think you want the opposite logic. If both variables are not blank, return the value.

VAR ValueCurrentPeriod =
    SELECTEDMEASURE ()
VAR ValuePreviousPeriod =
    CALCULATE ( SELECTEDMEASURE (), 'Time Intelligence'[Time Intelligence] = "PY" )
VAR Result =
    IF (
        ValueCurrentPeriod <> BLANK() && ValuePreviousPeriod <> BLANK(),
        ValueCurrentPeriod - ValuePreviousPeriod
    )
RETURN
    Result