Forum Discussion
Measure Total not correct - again!
- 6 years ago
I set up a new file and splitted the tables even further. Now its working perfectly - without any "IF HASONEFILTER".
Probably i had two problems in my Example file. First of all my data model hat an incorrect relation. My first step of aggregation is from my quantities/costs to the LV table. After that, cost per Position are splitted among different activities and then equally divided by the working days in my schedule. Second problem was a misunderstanding of the DAX Syntax for the filter.
In the end, i wanted to select a specific date and cost-group and get cross filtered tables as a result, whereby all costs shown are a sum of the costs per day. So if "Position 400" needs 5 days to finish and costs (overall) 100k, each day gets 20k. If i select 01.01-03.01 my result is 60k - in each table.
Heres my reworked solution
https://1drv.ms/u/s!AnnYPqfuqv4ChLdGg6gksXtMxQTpMA?e=QWYYDS
Thx for the help anyway! This Forum gave me the idea how to solve that issues.
Hi PowerBI_GER ,
I checked your pbix and the total seems correct. I'm not sure what you want. Cam you explain the logic and show the expected result to us?
Best regards,
Jay