Forum Discussion

ddbaker's avatar
ddbaker
Helper I
4 years ago
Solved

Help with SUMX using Multiple Criteria

Hi everyone,   I have an interesting dataset that gives me the annual amount of the subscription using invoices. The problem is that the annual customers are only billed once a year, but I have to ...
Need Help
  • v-yanjiang-msft's avatar
    v-yanjiang-msft
    4 years ago

    Hi ddbaker ,

    According to your description, I create a sample, measure is the same with you, it doesn’t calculate based on Customer ID, I use SUMX function in measure2, is it the outcome you expected?

     

     

    Best Regards,
    Community Support Team _ kalyj

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

v-yanjiang-msft's avatar
v-yanjiang-msft
Community Support
4 years ago

Hi ddbaker ,

According to your description, I create a sample, measure is the same with you, it doesn’t calculate based on Customer ID, I use SUMX function in measure2, is it the outcome you expected?

 

 

Best Regards,
Community Support Team _ kalyj

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