Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

The ultimate Microsoft Fabric, Power BI, Azure AI & SQL learning event! Join us in Las Vegas from March 26-28, 2024. Use code MSCUST for a $100 discount. Register Now

Reply
Ramesh-Raghuram
Frequent Visitor

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 I have 29 cases received out of which 13 are resolved and balance 16 are moved to upcoming weeks  . I want to show another bar in the same chart which shows the balance numbers are moved to in upcoming weeks. Please advise a measure

3 REPLIES 3
Deepak_22
Helper I
Helper I

Hello @Ramesh-Raghuram  , I understand that you have measures for "Cases Received This Week" and "Cases Resolved This Week." In that case, you can create the "Balance" measure as a calculated measure based on these measures. 

Assuming you have the following measures:

Cases Received This Week as [ReceivedThisWeek]

Cases Resolved This Week as [ResolvedThisWeek]

You can create a new measure for the "Balance" as follows:

 

Balance = [ReceivedThisWeek] - [ResolvedThisWeek]

 

 

 

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

Deepak_22
Helper I
Helper I

Hello @Ramesh-Raghuram , 

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.

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. 

Helpful resources

Announcements
Fabric Community Conference

Microsoft Fabric Community Conference

Join us at our first-ever Microsoft Fabric Community Conference, March 26-28, 2024 in Las Vegas with 100+ sessions by community experts and Microsoft engineering.

February 2024 Update Carousel

Power BI Monthly Update - February 2024

Check out the February 2024 Power BI update to learn about new features.

Fabric Career Hub

Microsoft Fabric Career Hub

Explore career paths and learn resources in Fabric.

Fabric Partner Community

Microsoft Fabric Partner Community

Engage with the Fabric engineering team, hear of product updates, business opportunities, and resources in the Fabric Partner Community.