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
Madhukumar_1996
New Member

@Need to show specific month value from cumulative sum calculated measure values

In Power bi, I had a cumulative calculated measure values month on month. This measure involved multiple sub measures. When I pull this final calculated cumulative measure in to the table or any visual month on month. Then I can be able to see the required values.

Now my scenario is I need to show final only specific current month and previous year same month value in separate card view (That means I need to show value from final calculated cumulative sum value). But when I wrote measure to filter it down to specific measure it was filter down previous measure as well and reduces the cumulative sum values. I need to show values from final calculated measure without any changes.

 

Could you please help me to resolve this problem.

 

@amitchandak@Ashish_Mathur , @tex628 will you please help me on this.


Scenario.PNG

3 REPLIES 3
Madhukumar_1996
New Member

Hi,

In the below screenshot we had cumulative target score month on month. From this we need to show only current month value in card visual. That means July 2023- 77.6. This value we need to represent in the card (Dynamically it has to show current month target score).

But if we applied any filter functions it will filter down in the cumulative sum calculation for the July month and reduces the actual value (Like- 43.2).

My requirement is to filter down for only current month from final output target value (These values not available in the column/ data source, completely imaginary calculated values)

Kindly suggest any alternative way to achieve this result. 

@amitchandak@Ashish_Mathur , @tex628 will you please help me on this?

Madhukumar_1996_1-1688661593242.jpeg

 

 

I still cannot understand.  Are you saying that you want to show thr value of the farthest month without taking into consideration any filter conditions?  Also, share the download of the PBI file.


Regards,
Ashish Mathur
http://www.ashishmathur.com
https://www.linkedin.com/in/excelenthusiasts/
Ashish_Mathur
Super User
Super User

Hi,

Clearly show the expected result and share the download link of the PBI file.


Regards,
Ashish Mathur
http://www.ashishmathur.com
https://www.linkedin.com/in/excelenthusiasts/

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.