Forum Discussion

SiroPW's avatar
SiroPW
Helper 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.

Ashish_Mathur's avatar
Ashish_Mathur
Super User
5 years ago

Hi,

Using the Query Editor, merge the Holdings Table into the Org Table.

Hope this helps.