How to avoid in Repeated values

[Anonymous]

Hello, Can you please help me writing the formula in DAX:

I want to create another column or measure that shows the total number of customers who have used a single product and multiple products without adding repeated values.  Can you please suggest a formula for it. Really appreciate your help and time. Thank you so much!

[Jihwan_Kim]

Hi, @Anonymous 

I am not sure if I understood your question correctly, but please check the below picture and the sample pbix file's link down below.

Product Used Measure =

IF (

ISFILTERED ( 'Table'[Customer ID] ),

CALCULATE (

COUNTROWS ( VALUES ( 'Table'[Product ID] ) ),

ALLEXCEPT ( 'Table', 'Table'[Customer ID] )

)

)

https://www.dropbox.com/s/lhaecsdh6l0o22y/assad.pbix?dl=0 

Hi, My name is Jihwan Kim.

If this post helps, then please consider accept it as the solution to help other members find it faster, and give a big thumbs up.

Linkedin: linkedin.com/in/jihwankim1975/

Twitter: twitter.com/Jihwan_JHKIM

[Anonymous]