Forum Discussion

SiroPW's avatar
SiroPW
Icon for Helper I rankHelper I
5 years ago
Solved

Show rows with zero value in table (two underlying data tables)

Hi,   I have two tables:   Table ORG id name org 123 a x 456 b y 789 c z   Table HOLDINGS id units value 123 50 500 789 20 200   I would like to out...
Need Help
  • V-lianl-msft's avatar
    V-lianl-msft
    5 years ago

    Hi SiroPW ,

     

    Create two measures:

    Measure = IF(ISBLANK(MAX('Table (2)'[units])),0,MAX('Table (2)'[units]))
    Measure 2 = IF(ISBLANK(MAX('Table (2)'[value])),0,MAX('Table (2)'[value]))

     

     

    Best Regards,
    Liang
    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Try CALCULATE(SUM[Value]), ALL(Table[ID]), Values(Table[ID]))