Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
2 years ago

Power BI Dax Measure

I have two columns in a line and clustered column chart which shows one with number of cases received in one week and the other shows number of cases resolved in the same week. For suppose in week 33...
Need Help
Deepak_22's avatar
Deepak_22
Helper I
2 years ago

Hello Anonymous , 

The below  measure calculates the balance by subtracting the sum of resolved cases from the sum of received cases, considering only the weeks up to the maximum week in your dataset. 

Balance = 
CALCULATE(
    SUM('Cases'[Received]) - SUM('Cases'[Resolved]),
    FILTER(
        ALL('Cases'),
        'Cases'[Week] <= MAX('Cases'[Week])
    )
)

 

 If you find this helpful, please provide a kudo and mark it as an accepted solution.

Anonymous's avatar
Anonymous
Not applicable
2 years ago

Hi Deepak, I do not have receved and resolved as fields . However I have a measure which shows cases received this week and cases resolved this week.