Percent % of Total Work only with Measure, but if you not slice

[lprbi]

Hi,

I'm using a Matrix and need a field that represents a percentage of the total, the solution I found it's create a measue:

(SUM(TABLE[VALUE])/CALCULATE(SUM(TABLE[VALUE]);ALL(TABLE[CUSTOMER_NAME]))*100)

The customer name it's the columns in the matrix

Work perfect, but if you slice a few customers, keeps counting all customers, not the total of the ones I sliced.

There is any way to solve this, with DAX?

A great feature it's add a % auto, running sum, cumulative sum options on matrix fields together with the SUM, COUNT, AVG, options that already have...

Many Thanks in Advance,

[lprbi · Accepted solution]

Solution: 

(SUM(TABLE[VALUE])/CALCULATE(SUM(TABLE[VALUE]);ALLSELECTED(TABLE[CUSTOMER_NAME]))*100)