Forum Discussion

rishari's avatar
rishari
Frequent Visitor
3 years ago

Make if statement optimized an total visible

I'm new to DAX. Kindly help me on this. If i use zero for else statement, I'm getting error as insufficient memory. I want to make the below dax faster and total to be visible.  DAX = IF (    ...
Need Help
Show and Tell
Ahmedx's avatar
Ahmedx
Icon for Super User rankSuper User
3 years ago
DAX =

VAR _t1 = SUM ( Counter_flag )
VAR _t2 = SUMX(DISTINCT( ColumnName ),1)
RETURN
IF (
      _t1 = 1,
      CALCULATE (_t2,
      KEEPFILTERS( 'table[Counter_flag]  = 1 )
)