Count the value based on condition

[Sparkizone]

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 name: Table 1

Column1 : Providers

Column2: Service Start Date

Providers	Service Start Date
A	22/03/2022
B	14/03/2022
C	----
C	----
----	----

Table name: Table 2 

Column1: Providers

Column2: Total Contracted Services

Providers	Total Contracted Services
A	16
B	50
C	98
D	5
---	---

Measures:

Target monthly = 

DIVIDE( 'Table2' [Total Contracted Services],12 )

CurrentFYMonth =

IF ( MONTH( TODAY() ) < 7, MONTH ( TODAY () ) + 6, MONTH ( TODAY () ) - 6 )

Target Services =

[Target monthly] * ([CurrentFYMonth])

Tracking A =  COUNTA('Table1'[Service Start Date]) - [Target Services]

Tracking B =  (Measure) -> Tracking A >= 0

I can make a table in Power BI as below in visualisation,

Providers	Tracking A	Tracking B
A	7	True
B	12	True
C	-3	False
D	56	True
E	-44	False
F	0	True
---	---	---

I want to count the number of providers with True and False separately.

Like 46 providers on Track(True), 15 providers are below ----

Thanks,

[Ashish_Mathur]

Hi,

Define the question in simple English, share some data and show the expected result.

[Sparkizone]

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 · Accepted solution]

Hi,

You may download my PBI file from here.

Hope this helps.

[Sparkizone]

Thanks for your help!

[Ashish_Mathur]

You are welcome.

[parry2k]

@Sparkizonebasically you are looking for dynamic segmentation, check this post and tweak it as you see fit Dynamic segmentation – DAX Patterns

✨ Follow us on LinkedIn and  to our YouTube channel

I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos to whoever helped to solve your problem. It is a token of appreciation!

⚡ Visit us at https://perytus.com, your one-stop shop for Power BI-related projects/training/consultancy.