Forum Discussion

aanyoti's avatar
aanyoti
Helper I
5 years ago
Solved

Compare two columns two tables and count difference

Hi, I need help.   I have two tables(Zonal Report and Zones) below with a many to one relationship. The Zonal Report has entries entered per week.       I would like to create a mea...
Need Help
  • amitchandak's avatar
    amitchandak
    5 years ago

    aanyoti , asuuming filter is coming from date . Use this measure with columns of zone table or in card

     

    countx(values(Zone[Cells]),if( isblank(calculate(countows('Zonal Report'))), [Cells],blank()))

amitchandak's avatar
amitchandak
Super User
5 years ago

aanyoti , asuuming filter is coming from date . Use this measure with columns of zone table or in card

 

countx(values(Zone[Cells]),if( isblank(calculate(countows('Zonal Report'))), [Cells],blank()))

  • aanyoti's avatar
    aanyoti
    Helper I
    5 years ago

    Thanks so much amitchandak , this worked!

     

    I have learnt something valuable using the COUNTX function.

     

    Thanks again!😎