cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
alifazal
Helper I
Helper I

count customer not buy and their see which customers

alifazal_0-1628624069556.png

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

alifazal_1-1628624259584.png

 

3 REPLIES 3
edhans
Super User
Super User

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.



Did I answer your question? Mark my post as a solution!
Did my answers help arrive at a solution? Give it a kudos by clicking the Thumbs Up!

DAX is for Analysis. Power Query is for Data Modeling


Proud to be a Super User!

MCSA: BI Reporting

 
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

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.

Helpful resources

Announcements
September Update

Check it Out!

Click here to learn more about the September 2022 updates!

Power BI Dev Camp Session 26

New Date - Check it Out!

Mark your calendars and join us on Thursday, October 6 at 11a PDT for a great session with Ted Pattison!

Top Kudoed Authors