Forum Discussion
Measure Total not correct - again!
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 ,
Is it possible to share the sample file that you present on the image (wetransfer, onedrive or google drive link)? or at least the structure of each table in a format that we can copy?
Please see this post regarding How to provide sample data in the Power BI Forum (courtesy of @ImkeF).
Hi PowerBI_GER ,
What is the formula that is incorrect, looking at the file you have send can you say expected result.
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.