Count values from one column on the basis of other column

[Anonymous]

PLease help

I have following data in PBI,

ID	Market	Market Unit	Status
701	NA	Midwest	Good
701	NA	Canada	Good
701	NA	South	V Good
701	Europe	ASGR	Good
701	Europe	Gallia	Good
701	Europe	Latin America	V Good

I have slicer for market, if I select no value from slicer than I want value :-

when i select no slicer count of "good" shld be 4

and count of v good shld be 2

when i select NA  count of "Good" should be 2

​and vgood should be 1

Please help

[ryan_mayu]

@Anonymous 

please try

Measure = calculate(countrows('table'),FILTER('table','table'[Status]="Good"))

[Anonymous]

thank you for solution really helpful, however I have status column count in my chart thus want the count for all the values of status together i.e Good and V Good count together for the waterfal chart

[v-deddai1-msft · Accepted solution]

Hi @Anonymous ,

Just use 

Measure = COUNT('Table'[Status])

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

Best Regards,

Dedmon Dai

[ryan_mayu]

@Anonymous 

you can try use

Measure = calculate(countrows('table')

If you want to count the number of single value, you can use distinctcount.

[parry2k]

@Anonymous you can try following as a measure

Count = IF ( HASONEFILTER ( Table[Statu] ), COUNTROWS ( Table ), 0 )

I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos 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.⚡

[Anonymous]

sorry, not working for me and other way out