Count No. of recurring values in a column against a specific value in another column

[Rizwan_A]

Hi all,

I am trying to calculate how many times a value repeat against another value. For example how many times Amy sedaris apear against Claude

 table

[speedramps · Accepted solution]

This is a really easy question, which suggests that you have done no Power Bi training.

Please do this FREE training before asking questions on the forum. Thank you.

https://docs.microsoft.com/en-us/training/modules/introduction-power-bi/

Try this ....

Create a table visual on your report canvas

Drag Director, Cast and then Cast again to the table visual

Click on 2nd Cast and select Count

Thanks for reaching out for help.

I put in a lot of effort to help you, now please quickly help me by giving kudos.

Remember we are unpaid volunteers and here to coach you with Power BI and DAX skills and techniques, not do the users job for them. So please click the thumbs up and accept as solution button. 

If you give someone a fish then you only give them one meal, but if you teach them how to fish then they can feed themselves and teach others for a lifetime.  I prefer to teach members on this forum techniques rather give full solutions and do their job. You can then adapt the technique for your solution, learn some DAX skills for next time and soon become a Power BI Super User like me. 

One question per ticket please. If you need to extend your request then please raise a new ticket.

You will get a quicker response and each volunteer solver will get the kudos they deserve. Thank you ! 

[speedramps · Accepted solution]

Thank you the PBIX and private messaging me 

Please do this free training https://www.wiseowl.co.uk/power-bi/videos/dax-powerbi/dax-quick-measures/

What you sent does not look like a real life question.

Actually it looks like an exam question or job skills test.

In which case you should be doing the training and learning the skills,

rather than asking this forum to give you the right answers.

That would cheating. 😀 😀😀

As a super user, I am happy to provide links to training to help you learm to pass your exam

but I wont cheat and give you the answers.  You need to study, learn, pratice and do the exam yourself.

Sorry this is not the answer you want .... but it is the best way to help you.

I am closing this ticket accordingly. 

Please do this free training https://www.wiseowl.co.uk/power-bi/videos/dax-powerbi/dax-quick-measures/

[speedramps]

Your screen print with "continents" does not make sense. What is that to do with films?

One question per ticket please. If you need to extend your request then please raise a new ticket.

I will close this question because I answer the count question.

You should not be asking easy question like how to count and get averages on this forum.

Please do this free training.

https://docs.microsoft.com/en-us/training/modules/introduction-power-bi/

Novices can also try use the quick measure wizards.

There is no need to ask how to count and calc averages here.

You can get quick answers and learn more by trying yourself  😀😀😀

If you give someone a fish then you only give them one meal, but if you teach them how to fish then they can feed themselves. Sorry but I wont help people who just ask questions and wont help themselves with learning.

[Rizwan_A]

We need to calculate average number of times a specific actor has worked with a director

[Rizwan_A]

Thanks for your prompt response. I do have studies power BI but the problemat hand is different. The result should be something like this:

[speedramps · Accepted solution]

This is a really easy question, which suggests that you have done no Power Bi training.

Please do this FREE training before asking questions on the forum. Thank you.

https://docs.microsoft.com/en-us/training/modules/introduction-power-bi/

Try this ....

Create a table visual on your report canvas

Drag Director, Cast and then Cast again to the table visual

Click on 2nd Cast and select Count

Thanks for reaching out for help.

I put in a lot of effort to help you, now please quickly help me by giving kudos.

Remember we are unpaid volunteers and here to coach you with Power BI and DAX skills and techniques, not do the users job for them. So please click the thumbs up and accept as solution button. 

If you give someone a fish then you only give them one meal, but if you teach them how to fish then they can feed themselves and teach others for a lifetime.  I prefer to teach members on this forum techniques rather give full solutions and do their job. You can then adapt the technique for your solution, learn some DAX skills for next time and soon become a Power BI Super User like me. 

One question per ticket please. If you need to extend your request then please raise a new ticket.

You will get a quicker response and each volunteer solver will get the kudos they deserve. Thank you ! 

[Rizwan_A]

Here is the link to the pbix file. https://drive.google.com/file/d/1F_OwqC0dH-45T6XBL1qJGV3mOjkMjzQH/view?usp=sharing 

[Rizwan_A]

Well this is not a simple average question. It os actually a very challenging question. If you are interested I can send you the pbix file, then you will know how tough it is 🙂