Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

Distinct Count With IF condition

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 mo...
Need Help
Tips and Tricks
  • V-lianl-msft's avatar
    V-lianl-msft
    4 years ago

    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.

Greg_Deckler's avatar
Greg_Deckler
Community Champion
5 years ago

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.