Forum Discussion

oakgogo's avatar
oakgogo
Icon for Helper II rankHelper II
2 years ago

how to avoid aggregation to two table when there are no relationship

the two table has no relationship, and I want to make the calculation return blank when look at "column" dimension, how to write the dax? thank you.

here is the two tables:

 

here is the dax and result, I want the sum calculation do not show when unrelated table is there：

CAL=calculation(sum(table[value]))

 

 

Need Help
Show and Tell

1 Reply

  • Dangar332's avatar
    Dangar332
    Icon for Resident Rockstar rankResident Rockstar
    2 years ago

    hi, oakgogo 

     

    try below

    measure = 
 if( 
    iscrossfiltered(firsttable),
    sum(table[value]),
    blank()
 )