count customer not buy and their see which customers

[alifazal]

I have this report that tells me distinc customers buying the items theitr interested in. I now want to see which customers did not buy the items using the same All im doing to find my percentage is using ditinct count and turning them into percentage and they seem to be fine now Id like to see e.g. who they other 25% of customers are that are not buying from the total  3703 customers

[edhans]

How to get good help fast. Help us help you.

How To Ask A Technical Question If you Really Want An Answer

How to Get Your Question Answered Quickly - Give us a good and concise explanation
How to provide sample data in the Power BI Forum - Provide data in a table format per the link, or share an Excel/CSV file via OneDrive, Dropbox, etc.. Provide expected output using a screenshot of Excel or other image. Do not provide a screenshot of the source data. I cannot paste an image into Power BI tables.

[alifazal]

So I think I have the solution. The formula below works as I want it to using the quick measure option. The only problem is I am forced to us 'IN' and list All the ITEMS in side{ " "}. I tried taking that part out and using just  DISTINCTCOUNT('VBISALES (2)'[BICUST]),

        'VBISALES (2)'[BIITEM])

hoever this did not work how do I use BIITEM without IN {""} 

The formula is below in full

Thanks 

Difff =

VAR __BASELINE_VALUE =

    CALCULATE(

        DISTINCTCOUNT('VBISALES (2)'[BICUST]),

        'VBISALES (2)'[BIITEM] IN { "10009", "10006" }

    )

VAR __MEASURE_VALUE = DISTINCTCOUNT('VBISALES (2)'[BICUST])

RETURN

    __MEASURE_VALUE - __BASELINE_VALUE

[v-jingzhang]

Hi @alifazal 

Try DISTINCT or VALUES function to replace the {"   "} part, like DISTINCT('table'[column]) or VALUES('table'[column]).

You can try modifying the measure like below:

Difff =

VAR __IDs = DISTINCT('table'[column])          // change table and column names accordingly

VAR __BASELINE_VALUE =

    CALCULATE(

        DISTINCTCOUNT('VBISALES (2)'[BICUST]),

        'VBISALES (2)'[BIITEM] IN __IDs

    )

VAR __MEASURE_VALUE = DISTINCTCOUNT('VBISALES (2)'[BICUST])

RETURN

    __MEASURE_VALUE - __BASELINE_VALUE

Regards,
Community Support Team _ Jing
If this post helps, please Accept it as the solution to help other members find it.