Forum Discussion
Issue with SUMX including null values in formula
I have the following dataset that includes a date, a store ID, and a profit value for that month. One site has not compiled it's report yet for the time frame: Date ID Profit 10/1/2019 ...
Positive Values = SUMX(
SUMMARIZE(FILTER(
Table,
NOT(ISBLANK(Table[Profit]))
),
Table[ID]
),
IF(CALCULATE(SUM(Table[Profit])) >= 0, 1 , BLANK()))
Positive Values = SUMX(
SUMMARIZE(
FILTER(
Table,
NOT(ISBLANK(Table[Profit]))
),
Table[ID]
),
IF(CALCULATE(SUM(Table[Profit])) >= 0, 1 , BLANK()))
Thank you very much!