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...
  • v-ljerr-msft's avatar
    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