Forum Discussion
Conditional CALCULATE based on if a table ISEMPTY
I'm trying to create a measure that conditionally picks what type of filter to used based on if the results of one filter returns an empty table. This measure feeds a line chart. The DAX is below.
The problem I'm having is this: If the ISEMPTY() evalutes to TRUE, only metric2 values are graphed, but if ISEMPTY() evaluates to FALSE, BOTH metric1 and metric2 values are graphed.
I'm still investigating, but can you see anything wrong with the DAX? Thanks!
Out = IF(
ISEMPTY(
CALCULATETABLE(
'table',
'table'[metric] = "metric1"
)
),
CALCULATE(
SUM('table'[score]),
FILTER('table', 'table'[metric] = "metric2")
),
CALCULATE(
SUM('table'[score]),
FILTER('table', 'table'[metric] = "metric1")
)
)
2 Replies
UPDATE: It has something to do with the conditional statement. If I substitule "TRUE" or "FALSE" instead of the ISEMPTY() function, it works correctly.
Hi wzorn40 ,
Could you tell me if your problem has been solved? If it is, kindly Accept it as the solution. More people will benefit from it. Or if you are still confused about it, please provide me with more details about your table and your problem or share me with your pbix file after removing sensitive data.
Thanks for your efforts & time in advance.
Best regards,
Community Support Team_ Binbin Yu
