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-aatheeque]

Hi @studentBielbas ,

Has your issue been resolved? If a community member's response addressed your query, please consider marking it as Accepted Answer and click Yes if you found it helpful.

If you have any further questions, feel free to reach out.
Thank you for being a valued member of the Microsoft Fabric Community Forum!

[v-aatheeque]

Hi @studentBielbas ,

Just looping back on your question about one to many count with blanks, @ryan_mayu @Ashish_Mathur  has shared some helpful input that might guide you in the right direction.

If that response solved the issue, it would be great if you could mark it as the Accepted Answer it not only closes the loop but also helps others who might be facing a similar situation.

If you're still unsure or need further guidance, feel free to drop us more details — we're here to help.

Thanks again for being part of the Microsoft Fabric Community!

[Anonymous]

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?