Forum Discussion
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]
)
In case it answered your question, please accept the solution to help other members find it. Appreciate Your Kudos.
SpartaBI Logo
Visit SpartaBI website Visit SpartaBI Linkdin Visit SpartaBI Facebook
Showcase Report – Contoso By SpartaBI
1 Reply
- SpartaBI
Community Champion
Cocrodile you need to wrap your measure with SUMX.
MEASURE =
SUMX(
VALUES('Table'[The column you put in your table visual]),
[Week_blank]
)
In case it answered your question, please accept the solution to help other members find it. Appreciate Your Kudos.
SpartaBI Logo
Visit SpartaBI website Visit SpartaBI Linkdin Visit SpartaBI Facebook
Showcase Report – Contoso By SpartaBI