Forum Discussion

Thalian's avatar
Thalian
Frequent Visitor
9 years ago
Solved

How to get right total?

I have a data like this:    alaALM is sum of three values and alakk = alaALM * dckk / dc dc is distinctcount on slicer selection (there are selected 4 months) and dckk is distinctcount to nu...
Need Help
  • v-ljerr-msft's avatar
    v-ljerr-msft
    9 years ago

    Hi Thalian,

     

    According to your description, using SUMX Function (DAX) should be a possible solution in this case. Here is an good article which explains different scenarios to use SUM vs SUMX in DAX for your reference.:smileyhappy:

     

    If that is not the case, could you post your table structures, the measures you're using with some sample data in this case? It is better to share a sample pbix file. You can upload it to OneDrive or Dropbox and post the link here. Do mask sensitive data before uploading.:smileyhappy:

     

    Regards

v-ljerr-msft's avatar
v-ljerr-msft
Microsoft Employee
9 years ago

Hi Thalian,

 

According to your description, using SUMX Function (DAX) should be a possible solution in this case. Here is an good article which explains different scenarios to use SUM vs SUMX in DAX for your reference.:smileyhappy:

 

If that is not the case, could you post your table structures, the measures you're using with some sample data in this case? It is better to share a sample pbix file. You can upload it to OneDrive or Dropbox and post the link here. Do mask sensitive data before uploading.:smileyhappy:

 

Regards

Thalian's avatar
Thalian
Frequent Visitor
9 years ago

Thanks to that link! I know that I need to do that using sumx but doen't know the right way. Your link was superb!