Forum Discussion

ansar's avatar
ansar
Icon for Helper II rankHelper II
5 years ago
Solved

Distinct count with filter showing wrong numbers

Hi, Can any one help here what is the correct DAX formula ,    I have a measure to find out unique numbers of customers who is contributing 80% of the provision value (Measure [Prov USD])    Ima...
Need Help
  • ansar's avatar
    ansar
    4 years ago

    Thanks Fowmy VahidDM v-yingjl 

     

    It got resolved through FILTER functions.

     

    Customers Contribute 80% =
    CALCULATE(
    DISTINCTCOUNT(Data[Cr. Acc]),
    FILTER(ADDCOLUMNS(FILTER('Customer DB',[Cumulative Prov %]),"**bleep** %",[Cumulative Prov %]),[Cumulative Prov %]<=.8))

     

    Regards,

    Ansar.

ansar's avatar
ansar
Icon for Helper II rankHelper II
4 years ago

Thanks Fowmy VahidDM v-yingjl 

 

It got resolved through FILTER functions.

 

Customers Contribute 80% =
CALCULATE(
DISTINCTCOUNT(Data[Cr. Acc]),
FILTER(ADDCOLUMNS(FILTER('Customer DB',[Cumulative Prov %]),"**bleep** %",[Cumulative Prov %]),[Cumulative Prov %]<=.8))

 

Regards,

Ansar.