Forum Discussion

JbPa33's avatar
JbPa33
Helper I
4 years ago
Solved

Formula between 2 tables

Hello,   I'm begginer on Power BI and i have a problem with a formula. I have 2 differents tables :                 One table with the contract number and the commercial and an other tabl...
Need Help
  • MahyarTF's avatar
    MahyarTF
    4 years ago

    Hi,

    In the main Table(including the Commercial column) create the below measure :

    Number of Missing = COALESCE( CALCULATE(COUNTROWS(Sheet31)),0)

     

MahyarTF's avatar
MahyarTF
Memorable Member
4 years ago

Hi,

In the main Table(including the Commercial column) create the below measure :

Number of Missing = COALESCE( CALCULATE(COUNTROWS(Sheet31)),0)

 

  • JbPa33's avatar
    JbPa33
    Helper I
    4 years ago

    Thank you, it's perfect !