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.

Reply
Marcorelio
Regular Visitor

Percent usage in matrix type table in Power BI.

I am in doubt as to how to perform percentages when I go to the next level of drill down in my matrix, the first line was ok, but when I go down the level, 100% is displayed in all data.

 

My base formula is: 

Total Sales Underline = CALCULATE([Sale Qty Weight KG], ALLSELECTED('Item'[Underline - Name]))
% Share Underlines = DIVIDE([Sales Qty Weight KG], [Total Sales Underlines])
 

but there are other levels that need the percentage. Can someone help me?

 

how I use the other lines, like:


Item [Group - Name]
Item - Description [Description]

 

Marcorelio_0-1677692441464.png

 

1 ACCEPTED SOLUTION
FreemanZ
Super User
Super User

hi @Marcorelio 

 

try like:

% Share Underlines = 
DIVIDE(
    [Sales Qty Weight KG], 
    CALCULATE(
        [Sale Qty Weight KG], 
        ALLSELECTED('Item'[Description])
)

 

Tried to simulate your case. Supposing your table looks like:

FreemanZ_0-1677724447584.png

then try to plot the matrix with a measure like:

%Share = 
DIVIDE(
    SUM(TableName[Qty]), 
    CALCULATE(
        SUM(TableName[Qty]), 
        ALLSELECTED(TableName[Description])
    )
)

it worked like:

FreemanZ_1-1677724531300.png

 

 

 

View solution in original post

3 REPLIES 3
FreemanZ
Super User
Super User

hi @Marcorelio 

 

try like:

% Share Underlines = 
DIVIDE(
    [Sales Qty Weight KG], 
    CALCULATE(
        [Sale Qty Weight KG], 
        ALLSELECTED('Item'[Description])
)

 

Tried to simulate your case. Supposing your table looks like:

FreemanZ_0-1677724447584.png

then try to plot the matrix with a measure like:

%Share = 
DIVIDE(
    SUM(TableName[Qty]), 
    CALCULATE(
        SUM(TableName[Qty]), 
        ALLSELECTED(TableName[Description])
    )
)

it worked like:

FreemanZ_1-1677724531300.png

 

 

 

Good morning,

 

It worked, thank you very much!

 

In this case, I used the formula as:

% Participation Underlines = DIVIDE(
    [Sale Qty Weight KG],
     CALCULATE([Sale Qty Weight KG],
     ALLSELECTED('Item - Description'[Item - Description]), ALLSELECTED('Item'[Group - Name]), ALLSELECTED('Item'[Underline - Name])
))

 

Marcorelio_0-1677752961824.png

 

andhiii079845
Super User
Super User

What happended when you add Item [Group - Name]
Item - Description [Description]  in the this statement? Like;

ALLSELECTED('Item'[Underline - Name],Item [Group - Name])

 





Did I answer your question? Mark my post as a solution!

Proud to be a Super User!




Helpful resources

Announcements
RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

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

MayPowerBICarousel

Fabric Monthly Update - May 2024

Check out the May 2024 Fabric update to learn about new features.

LearnSurvey

Fabric certifications survey

Certification feedback opportunity for the community.

Top Solution Authors