Percentage of each customer

[at9727]

Hello All, 

I have a table with multiple customers with multiple categories and their printed meters. I need to get a new column using DAX that shows the percentage for EACH customer of how much they have printed within each category for their OWN total. For example, from the screenshot below, the first two rows should return '8.6%' and '91.3%' respectively.

 

Basically, I need the percentage of each customer for their own printed meters for each category. Hopefully someone can help. Thank you in advance. 

[Ashish_Mathur]

Hi,

Write this measure

=CALCULATE(SUM(Data[squaremeter]),ALL(Data[Category$]))

Hope this helps.

[at9727]

Thanks for your reply. 

However, the solution I need is a column with the percentage for each customer.

So, for example, the first 2 rows of the new column should be '8.6%' and '91.3%' respectively. 

[Ashish_Mathur]

Hi,

That is what my measure should return?

[at9727]

The measure stated gives the following column where it shows the percentage across the entire customer base rather than across its own total.  I'm looking for a measure that gives a percentage for each customer for each category for their own total and not all the customers. So, in essence, all the percentages of a single customer should add up to 100%. 

[Ashish_Mathur]

Hi,

Does this work?

=CALCULATE(SUM(Data[squaremeter]),ALLEXCEPT(Data,Data[sn]))

I have assumed that sn is the Customer column.

[at9727]

Thanks for the reply. 

Firstly, yes sn = customer 

Secondly, the results I get are as shown below in the screenshots. 

[Ashish_Mathur]

Hi,

My formula has to written as a measure (not a column).  If it still does not help, then share the link from where i can download your PBI file.

[at9727]

When writing the formula as a measure (for both measures) I get the screenshot as seen below. 

[Ashish_Mathur]

Hi,

As i have requested in my earlier post, share the link from where i can download your PBI file.