Forum Discussion

munchkin666's avatar
munchkin666
Icon for Helper II rankHelper II
5 years ago

Count blanks between two different tables without a single relationship

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)

3 Replies

  • v-xulin-mstf's avatar
    v-xulin-mstf
    Icon for Community Support rankCommunity Support

    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's avatar
      munchkin666
      Icon for Helper II rankHelper II

      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's avatar
        v-xulin-mstf
        Icon for Community Support rankCommunity Support

        Hi munchkin666

         

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

         

        Best Regards,

        Link