How to create a measure for count each sales group have how many distinct customer ?

[Paulyeo11]

Hi All

my PBI file :-

[vivran22]

Hey @Paulyeo11 

The issue is not clear from your description. Please share a sample data file/pbix file along with expected solution for quicker resolution.

Cheers!
Vivek

Blog: vivran.in/my-blog
Connect on LinkedIn
Follow on Twitter

[Paulyeo11]

Hi Vivran

https://www.dropbox.com/s/v96j87b664wwxsd/PB_TDS_V036%20xount%20coy.pbix?dl=0

[ryan_mayu]

@Paulyeo11 

Please see the attachment

[Paulyeo11]

Hi Ryan

Thank you for sharing.

From below image you can notice that G2 have 2 company.

But your expression only return 1.

[V-lianl-msft]

Hi @Paulyeo11 ,

Try to create a measure like this:

COUNT_ = IF(ISBLANK([Sales LYTD]),BLANK(),DISTINCTCOUNT(SALES[COMPANY]))

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

[Paulyeo11]

Hi V Linl

By the amit have provide me the below expression , look like your expression is more complicated , i have test with it , and i get the same result. So may i know what are purpose of those extra code ?

COUNT = Distinctcount(SALES[COMPANY])

Paul

[jaideepnema]

@Paulyeo11 I am not clear with your question..what exactly you want to count ?

[amitchandak · Accepted solution]

@Paulyeo11 , Distinctcount(Table[Customer]) , not working ?