Forum Discussion
Thalian
9 years agoFrequent Visitor
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...
- 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
Thiyags
9 years agoHelper II
can you attach the pbix file