Count blanks between two different tables without a single relationship

[munchkin666]

Hi. I have a dashboard with a couple of tables. I just created a dummy data in which I want to count:

- which exercises have any action (ID) against it. But i want to count only the ones with the bad results

- how many with bad results dont actually have any activity against it

- % of coveragre for each exercises: how many with bad results have any activity(ID)/ all with the bad results(with and withoht activity)

[v-xulin-mstf]

Hi @munchkin666

Could you provide pbix file after removing sensitive data?
Sample data and expected output would help tremendously.
Please see this post regarding How to Get Your Question Answered Quickly:
https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490

Best Regards,
Link

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

[munchkin666]

@v-xulin-mstf hi, thank you for a quick reply. I didnt solve the iossue, but found a way around. I wanted to attach pbix to my original question, but ithere is not option available, I could only post pictures. Something what could be improved on powerbi community site, I guess. 

[v-xulin-mstf]

Hi @munchkin666

You can put the files on a network drive and then share the public link.

Best Regards,

Link