Forum Discussion
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 table with the missing documents by contract. i would like to have in the first table the number of missing documents by contract :
I tried to count the number of documents in the second table and to retrieve this column with "related" but it doesn't work.
Someone has another idea ?
Thank you
Hi,
In the main Table(including the Commercial column) create the below measure :
Number of Missing = COALESCE( CALCULATE(COUNTROWS(Sheet31)),0)
