cancel
Showing results for
Did you mean:
Frequent Visitor

## How can I create a measure that gives me the totals of a set of values that are being filtered?

Hello,

Is there a way to write a measure that would be the total of a specific field of data without its filter and without removing that filter, that is currently filtered? (sorry if that was confusing)

The values in PercentRespTestNumerator are correct. However, I need all the values in New Denominator to equal the total of 674.75, 161 and 887. In that way, my other line (not shown) can calculate 674.75/sum , 161/sum, 887/sum, to give me a percentage.

Is this a way to do this? Thanks in advance.

1 ACCEPTED SOLUTION
Community Support

I think you might want use ALLEXCEPT function or ALL function.

Here's a simple sample.

``ALL function = CALCULATE(SUM('Table'[Value]),ALL('Table'))``
``ALLEXCEPT function = CALCULATE(SUM('Table'[Value]),ALLEXCEPT('Table','Table'[User]))``

Best Regards,

Stephen Tao

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

3 REPLIES 3
Community Support

I think you might want use ALLEXCEPT function or ALL function.

Here's a simple sample.

``ALL function = CALCULATE(SUM('Table'[Value]),ALL('Table'))``
``ALLEXCEPT function = CALCULATE(SUM('Table'[Value]),ALLEXCEPT('Table','Table'[User]))``

Best Regards,

Stephen Tao

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Super User IV

@dillontoramall , not very clear

Denominator =

calculate([PercentRespTestNumerator], allselected(Table))

Proud to be a Super User!

Frequent Visitor

Hi, in an attempt to be more clear. I have the following measure:

NewDenominator = (sum(Data[Employee Hours]) - (CALCULATE(SUM(Data[Employee Hours]), fVariableData[JobType] = "WorkJob1") + CALCULATE(SUM(Data[Employee Hours]), fVariableData[JobType] = "WorkJob2")))

This gives me the correct total of lets say 5000. Now this data is filtered by specific department. I want to make it that when I create a table and list the numerator and denominator out, the numerator has its values per department, but the denominator has that fixed 5000 value. The numerator is displaying what I want, the denominator is not.

Announcements