Measure Total not correct - again!

[PowerBI_GER]

Hi! Yes, it's not the first post and no, i couldn't solve the problem on my own 😉

I've got a problem shown below. The Measure total of my "CostPerDay" is not showing the sum of the created column. I tried to work with IF and HASONEFILTER, but i don't know how to summarize my calculated results to sum them up in total. 

Yet, i reduced my DAX to

CostPerDay =

(CALCULATE([Cost_portion], ALLSELECTED(QA[Position]))/

(CALCULATE(SUM(Timetable[Duration]), ALLSELECTED(Timetable[Duration]))))

(2nd Problem) In addition, i want to replace the "Cost_portion" with my new Measure, therefore i can filter either an Article, OR a Position, OR a specific Timerange OR some of them crossover 😄

Thx for any kind of help in advance!

[Anonymous]

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

[MFelix]

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).

[PowerBI_GER]

Hey @MFelix 

There we go!

https://1drv.ms/u/s!AnnYPqfuqv4ChLdFmJ3tKbR452ofbA?e=fJogRk

[MFelix]

Hi @PowerBI_GER ,

What is the formula that is incorrect, looking at the file you have send can you say expected result.

[PowerBI_GER · Accepted solution]

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.