cancel
Showing results for
Did you mean:

Grow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric 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!!
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!!

Announcements

#### Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

#### Power BI Monthly Update - June 2024

Check out the June 2024 Power BI update to learn about new features.

#### New forum boards available in Real-Time Intelligence.

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

Top Solution Authors
Top Kudoed Authors