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

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

Anonymous
Not applicable

Ponderation

Hello. I have a table for sellings like this:

 Product % Montly var Hammer 20 -33% Cutter 17 6% Others 73 90%

In the cell % I have the total, but with the option "show as porcentaje". The thing is that the Monthly var is calculated against the total, I want it to be calculated against the % of the total.

How can I make a measure that equals the "Show as %" option to work agains it?

Thanks

1 ACCEPTED SOLUTION
Anonymous
Not applicable

Solved.

With

%TotalSells = DIVIDE([Total Sells], CALCULATE([Total Sells], ALL(Products[all_products])))

I have the measure to show the %s. I made a MoM quick measure over it and got the needed result.

Thanks!!
1 REPLY 1
Anonymous
Not applicable

Solved.

With

%TotalSells = DIVIDE([Total Sells], CALCULATE([Total Sells], ALL(Products[all_products])))

I have the measure to show the %s. I made a MoM quick measure over it and got the needed result.

Thanks!!

Helpful resources

Announcements

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

Fabric certifications survey

Certification feedback opportunity for the community.

Top Solution Authors
Top Kudoed Authors