Distinct Count With IF condition

[Anonymous]

Hi I have a list of Sku that I need to distinct count, that will return the number of times that a Sku appears in the column. So that an if condition can then be put in place so that if it appears more than 5 times the statement returns a yes if not then a no.

I've tried CALCULATE with filters but nothing is returning the correct value.

Sku column is called SKU_ID

Any help apprecitated.

[V-lianl-msft · Accepted solution]

Hi @Anonymous ,

What conditions are your counts based on?No idea what you are looking for, it is a bit confusing.

The results in your picture cannot be achieved. You need to be based on the context of other columns to get similar results.

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

[Anonymous]

Sample of Data is below. Its the SKu column I need distinct counting to get the output Ive already posted.

Thanks

[Anonymous]

Hi Greg 

Below is what Iim trying to achieve.

[Greg_Deckler]

@Anonymous Hard to say with the information provided but you can try COUNTROWS(FILTER(...),...) Also, COUNTROWS(DISTINCT(FILTER(...))) Going to depend. Sorry, having trouble following, can you post sample data as text and expected output?
Not really enough information to go on, please first check if your issue is a common issue listed here: https://community.powerbi.com/t5/Community-Blog/Before-You-Post-Read-This/ba-p/1116882

Also, 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

The most important parts are:
1. Sample data as text, use the table tool in the editing bar
2. Expected output from sample data
3. Explanation in words of how to get from 1. to 2.