cancel
Showing results for 
Search instead for 
Did you mean: 

Fabric is Generally Available. Browse Fabric Presentations. Work towards your Fabric certification with the Cloud Skills Challenge.

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
PBI November 2023 Update Carousel

Power BI Monthly Update - November 2023

Check out the November 2023 Power BI update to learn about new features.

Community News

Fabric Community News unified experience

Read the latest Fabric Community announcements, including updates on Power BI, Synapse, Data Factory and Data Activator.

Power BI Fabric Summit Carousel

The largest Power BI and Fabric virtual conference

130+ sessions, 130+ speakers, Product managers, MVPs, and experts. All about Power BI and Fabric. Attend online or watch the recordings.

Top Solution Authors
Top Kudoed Authors