Forum Discussion

danielpaduck's avatar
danielpaduck
Helper III
2 years ago
Solved

Conditional Measure Is Not Totaling Correctly

Hi,   I have the following report for test:     I have regular hours, then forecasted hours (regular x 2) and then a conditional measure that states the following:     Hours (Conditiona...
Need Help
  • bestevezdyb's avatar
    bestevezdyb
    2 years ago

    you can try, assuming you have the values in different tables. But it is as TomMartens  says, without the data model we cannot give an accurate answer.

     

    SUMX(
        FILTER(
            TableHour,
            TableHour[date] >= 201901 && TableHour[date] <= 201901
        ),
        TableHour[hour]
    )
    +
    SUMX(
        FILTER(
            TableHourF,
            TableHourF[date] > 201901
        ),
        TableHourF[hour]
    )
bestevezdyb's avatar
bestevezdyb
Frequent Visitor
2 years ago

Have you tried the measure I have provided?

danielpaduck's avatar
danielpaduck
Helper III
2 years ago

I will try today but the periods will need to be more dyamic instead of hard coding period ranges. Thanks!