topic Re: Apply a calculation in a filtered view (Cost Value) in DAX Commands and Tips

Apply a calculation in a filtered view (Cost Value)

Anonymous — Fri, 24 Jan 2020 20:32:09 GMT

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?

Re: Apply a calculation in a filtered view (Cost Value)

kentyler — Sat, 25 Jan 2020 02:46:16 GMT

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.

Re: Apply a calculation in a filtered view (Cost Value)

Anonymous — Fri, 31 Jan 2020 18:25:23 GMT

Thats what i did and worked. Thanks Kentyler