Forum Discussion

Sparkizone's avatar
Sparkizone
Frequent Visitor
4 years ago
Solved

Count the value based on condition

Hi Everyone,   I've tried to count the number of 'Providers' by Measure conditions but no luck last few days.  Can you please share your ideas?     So, a column and measures are like   Table ...
General Comment
Need Help
Show and Tell
Tips and Tricks
  • Ashish_Mathur's avatar
    Ashish_Mathur
    4 years ago

    Hi,

    You may download my PBI file from here.

    Hope this helps.

Sparkizone's avatar
Sparkizone
Frequent Visitor
4 years ago

Hello Ashish,

 

I've shared a sample data, and power bi file.

https://drive.google.com/drive/folders/1vwr8VnCAHtILKo9YrNz5znnz2-q2x_2f?usp=sharing

 

In short, I want to count how many distinct providers from both True and False to present/define either the number of on track proivders or not in Power BI.

For intance, within the data, I want to present "2 Providers are on Track", and "3 providers are below"

 

Hoping it makes sense. 

Thanks,

 

 

Ashish_Mathur's avatar
Ashish_Mathur
Super User
4 years ago

Hi,

You may download my PBI file from here.

Hope this helps.

  • Sparkizone's avatar
    Sparkizone
    Frequent Visitor
    4 years ago

    Thanks for your help!

    • Ashish_Mathur's avatar
      Ashish_Mathur
      Super User
      4 years ago

      You are welcome.