Can't show output measure

[Anonymous]

I create new measure but It's don't show data as below

My measure :

count = VAR __CurrentMeasure =

CALCULATE (

COUNT ( 'Before'[Date]),

FILTER ('Before',

( YEAR(DATEVALUE('Before'[Date])) = 2021 && MONTH(DATEVALUE('Before'[Date])) = 1 && 'Before'[Status(2021)]) = "live"

)

)

RETURN

IF ( ISBLANK ( __CurrentMeasure ), 0, __CurrentMeasure )

Please guide me about it.

[v-lionel-msft · Accepted solution]

Hi @Anonymous ,

This error occurs because the data types around the "=" are different and cannot be compared. For example, in my example, the left side of the equal sign is the date type, and the right side of the equal sign is the text type.

Try to force the data type of the'Before'[Date] column to be changed to a date type and use the following formula.

count = 
VAR __CurrentMeasure =
CALCULATE (
    COUNT ( 'Before'[Date]),
    FILTER (
        'Before',
        YEAR('Before'[Date]) = 2021 && MONTH('Before'[Date]) = 1 && 'Before'[Status(2021)] = "live"
    )
)
RETURN
IF ( 
    ISBLANK ( __CurrentMeasure ),
     0, __CurrentMeasure 
)

Best regards,
Lionel Chen

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

[themistoklis]

@Anonymous 

I think one of your closing parenthesis (right before = "live") is in the wrong place. Try the following:

count = VAR __CurrentMeasure =

CALCULATE (

COUNT ( 'Before'[Date]),

FILTER ('Before',

( YEAR(DATEVALUE('Before'[Date])) = 2021 && MONTH(DATEVALUE('Before'[Date])) = 1 && 'Before'[Status(2021)] = "live")

)

)

RETURN

IF ( ISBLANK ( __CurrentMeasure ), 0, __CurrentMeasure )

[amitchandak]

@Anonymous , Is data type is date not need use datevalue

Try like

count = VAR __CurrentMeasure =
CALCULATE (
COUNT ( 'Before'[Date]),
FILTER ('Before',
YEAR('Before'[Date]) = 2021 && MONTH('Before'[Date]) = 1 && 'Before'[Status(2021)] = "live"
)
)
RETURN
IF ( ISBLANK ( __CurrentMeasure ), 0, __CurrentMeasure )

[Anonymous]

@themistoklis  @amitchandak 

error as below.

Help me please.

[themistoklis]

@Anonymous 

Can you send a snapshot of the formula with the error as well?