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
1 ACCEPTED SOLUTION
@Cocrodile you need to wrap your measure with SUMX.
MEASURE =
SUMX(
VALUES('Table'[The column you put in your table visual]),
[Week_blank]
)
@Cocrodile you need to wrap your measure with SUMX.
MEASURE =
SUMX(
VALUES('Table'[The column you put in your table visual]),
[Week_blank]
)
Helpful resources
New forum boards available in Real-Time Intelligence.
Ask questions in Eventhouse and KQL, Eventstream, and Reflex.
Power BI Monthly Update - May 2024
Check out the May 2024 Power BI update to learn about new features.
Europe’s largest Microsoft Fabric Community Conference
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
