topic Re: Filter data on specific value to calculate % share in DAX Commands and Tips

Filter data on specific value to calculate % share

Anonymous — Tue, 25 Apr 2023 17:36:05 GMT

Hello,

I have following kind of value

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

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

Re: Filter data on specific value to calculate % share

FreemanZ — Wed, 26 Apr 2023 07:17:58 GMT

hi Anonymous

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:

Re: Filter data on specific value to calculate % share

Anonymous — Wed, 26 Apr 2023 13:50:37 GMT

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