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

Don't miss out! 2025 Microsoft Fabric Community Conference, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount. Prices go up February 11th. Register now.

Reply
Anonymous
Not applicable

Apply a calculation in a filtered view (Cost Value)

Dears.

 

Need your help with my costs reports. I´ve created a report where i splitted the cloud costs from my company using some filters, i´ve splitted it left cost and rigth cost, this split was done using filters from columns that i have in my data.

Example the left side data is set when i have the compose of two filters, Resoure Group name and subscription name. same thing for right side.

 

Now i need to apply a percentage calculation for each values (Left and Right), i need help to find a way to apply this calculation into this filtered view. Do you guys know how to do that?

1 ACCEPTED SOLUTION
kentyler
Solution Sage
Solution Sage

It's hard to tell without seeing your data.

One suggestion is to do the two original calculations in measures

Then you can use those 2 measures in a 3rd measure to calculate your percent.

 





Did this post answer your question? Mark it as a solution so others can find it!

Help when you know. Ask when you don't!




Join the conversation at We Talk BI find out more about me at Slow BI


View solution in original post

2 REPLIES 2
kentyler
Solution Sage
Solution Sage

It's hard to tell without seeing your data.

One suggestion is to do the two original calculations in measures

Then you can use those 2 measures in a 3rd measure to calculate your percent.

 





Did this post answer your question? Mark it as a solution so others can find it!

Help when you know. Ask when you don't!




Join the conversation at We Talk BI find out more about me at Slow BI


Anonymous
Not applicable

Thats what i did and worked. Thanks Kentyler

Helpful resources

Announcements
Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!

Jan25PBI_Carousel

Power BI Monthly Update - January 2025

Check out the January 2025 Power BI update to learn about new features in Reporting, Modeling, and Data Connectivity.

December 2024

A Year in Review - December 2024

Find out what content was popular in the Fabric community during 2024.