Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Summing Dax Measures

What I would like to do is have 6 dax measures. Each one is same actually, 

2020ManuelEforMaliyeti = SUMX('2020ManuelEforData','2020ManuelEforData'[Saat]*RELATED(RateList2020[Saatlik Ücret]))
2020BUEforMaliyeti = SUMX('2020TimeSheetPlusListBU','2020TimeSheetPlusListBU'[Saat]*RELATED(RateList2020[Saatlik Ücret]))
2020SUEforMaliyeti = SUMX('2020TimesheetPlusListSU','2020TimesheetPlusListSU'[Saat]*RELATED(RateList2020[Saatlik Ücret]))
2021ManuelEforMaliyeti = SUMX('2021ManuelEforData','2021ManuelEforData'[Saat]*RELATED(RateList2021[Saatlik Ücret]))
2021BUEforMaliyeti = SUMX('2021TimesheetPlusListBU','2021TimesheetPlusListBU'[Saat.Duzgun]*RELATED(RateList2021[Saatlik Ücret]))
2021SUEforMaliyeti = SUMX('2021TimesheetPlusListSU','2021TimesheetPlusListSU'[Saat]*RELATED(RateList2021[Saatlik Ücret]))
 

 

AllTimesheetSum is appending of "2020ManuelEforData", "2020TimeSheetPlusListBU", "2020TimesheetPlusListSU", "2021ManuelEforData", "2021TimesheetPlusListBU" and, "2021TimesheetPlusListSU".

 
Basically each table multiplying that year's ratelist. And calculating effort cost individually. After all these I am summing all these measure in a measure as;
 
EforMaliyetiToplamı =
('2020ManuelEforData'[2020ManuelEforMaliyeti]) + ('2020TimeSheetPlusListBU'[2020BUEforMaliyeti]) + ('2020TimesheetPlusListSU'[2020SUEforMaliyeti]) + ('2021ManuelEforData'[2021ManuelEforMaliyeti]) + ('2021TimesheetPlusListBU'[2021BUEforMaliyeti]) + ('2021TimesheetPlusListSU'[2021SUEforMaliyeti])
 
Measure of EforMaliyetiToplamı is in AllTimesheetSum table.
 
But by doing this way, datas are not showing according to years. As you can see datas are for 2020 and 2021. I want to be able to select 2020 or 2021 with slicer.
 

 

 

1 Reply

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    Anonymous 

     

    What you're doing goes totally against the philosophy of Power BI. This will create even more problems in the future. Please create a good model first according to Best Practices and your problems will be gone in a minute. You can start with this article: Understand star schema and the importance for Power BI - Power BI | Microsoft Docs

     

    Then I'd kindly suggest you watch some YT vids about how to create a good model in PBI.