one to many count with blanks

[studentBielbas]

25

[Ashish_Mathur]

Hi,

Measure1 = countrows('Table2') should count all the rows of Table2.  Whereas Measure2 = calculate([Measure1],'Table2'[idof1]<>blank()) should count rows from Table2 where idof1 <> blank

[studentBielbas]

2

[Ashish_Mathur]

With just that little information, atleast i am unable to help you.

[v-heq-msft]

Hi @studentBielbas ,
Thanks for ryan_mayu reply.

First you need to make sure the relationship is correct: in the Model view of Power BI, make sure that the id of table1 and the idof1 of table2 have been correctly established (usually a one-to-many relationship). For the relationship filtering direction: if you only need to filter table2 from table1, keep the default one-way filtering

Counts the rows where idof1 is not empty:

Rows with idof1 = COUNTROWS(FILTER(table2, NOT(ISBLANK(table2[idof1]))))

Best regards,
Albert He

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

[ryan_mayu]

could you pls provide some sample data and expected output?