Forum Discussion

GKs's avatar
GKs
Frequent Visitor
6 years ago
Solved

Calculate Purchase frequency

Hi everyone, I cannot understand why the total does not SUM correctly. In the following table I am making measurements of: Id_Name = Distinctcount (Table1 [Id_Name]) ... OK Sales Check = Distinctc...
Need Help
Show and Tell
Tips and Tricks
  • v-easonf-msft's avatar
    v-easonf-msft
    6 years ago

    Hi , GKs 

    Please check this sample file:
    pbix attached

     

    Try measure as below:

    Measure = SUMX(VALUES('Table1'[Id_Name]),'Table1'[2 or more Purchas])

     

     

    Best Regards,
    Community Support Team _ Eason
    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

v-easonf-msft's avatar
v-easonf-msft
Community Support
6 years ago

Hi , GKs 

Please check this sample file:
pbix attached

 

Try measure as below:

Measure = SUMX(VALUES('Table1'[Id_Name]),'Table1'[2 or more Purchas])

 

 

Best Regards,
Community Support Team _ Eason
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.