cancel
Showing results for 
Search instead for 
Did you mean: 

Fabric is Generally Available. Browse Fabric Presentations. Work towards your Fabric certification with the Cloud Skills Challenge.

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
PBI November 2023 Update Carousel

Power BI Monthly Update - November 2023

Check out the November 2023 Power BI update to learn about new features.

Community News

Fabric Community News unified experience

Read the latest Fabric Community announcements, including updates on Power BI, Synapse, Data Factory and Data Activator.

Power BI Fabric Summit Carousel

The largest Power BI and Fabric virtual conference

130+ sessions, 130+ speakers, Product managers, MVPs, and experts. All about Power BI and Fabric. Attend online or watch the recordings.

Top Solution Authors
Top Kudoed Authors