Forum Discussion
Cocrodile
Helper I
Helper IWhy measure ?
Why does a given measurement give no result?
I'm trying to calculate a measure that gives me a result of 1 when that measure is empty.
Week_blank = if([Measure]=BLANK(),1,0) |
The result does not give me the total
I want total = 5
Cocrodile you need to wrap your measure with SUMX.
MEASURE =
SUMX(
VALUES('Table'[The column you put in your table visual]),
[Week_blank]
)
