Forum Discussion

PowerBI_GER's avatar
PowerBI_GER
Frequent Visitor
6 years ago
Solved

Measure Total not correct - again!

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!

 

 

 

Need Help
  • PowerBI_GER's avatar
    PowerBI_GER
    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.

5 Replies