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

Enhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.

Reply
angshu
Frequent Visitor

Filter data on specific value to calculate % share

Hello,

I have following kind of value

angshu_0-1682442998383.png

I need to calculate % share of each sales person against Zone Total. Following is the format of the required representation

angshu_1-1682443109244.png

Not be able to figure out how to write the dax for the % share. 

 

1 ACCEPTED SOLUTION
FreemanZ
Super User
Super User

hi @angshu 

try to plot a matrix visual with

 

1) source column

2) a calculated column like:

YYMM = FORMAT(DATE([Year], [Month], 1), "mmm-yy")

3) two measures like:

Total Sales = SUM(data[TotalSales])
% of Share of Zone = 
DIVIDE(
    SUM(data[TotalSales]),
    CALCULATE(
        SUM(data[TotalSales]),
        ALL(data[Source])
    )
)*2

it worked like:

FreemanZ_2-1682493407872.png

View solution in original post

2 REPLIES 2
angshu
Frequent Visitor

Thank you for your reply. Since there will be some filters in this page I may have to change the dax for % share and to include the source column in the ALL filter. Let me try

FreemanZ
Super User
Super User

hi @angshu 

try to plot a matrix visual with

 

1) source column

2) a calculated column like:

YYMM = FORMAT(DATE([Year], [Month], 1), "mmm-yy")

3) two measures like:

Total Sales = SUM(data[TotalSales])
% of Share of Zone = 
DIVIDE(
    SUM(data[TotalSales]),
    CALCULATE(
        SUM(data[TotalSales]),
        ALL(data[Source])
    )
)*2

it worked like:

FreemanZ_2-1682493407872.png

Helpful resources

Announcements
July 2025 community update carousel

Fabric Community Update - July 2025

Find out what's new and trending in the Fabric community.

July PBI25 Carousel

Power BI Monthly Update - July 2025

Check out the July 2025 Power BI update to learn about new features.