cancel
Showing results for
Did you mean:
Highlighted
Regular Visitor

## Slicer filtering when it shouldn't

I am written the following Dax formula to calculate the average max words each vendor can do. When I put that formula into my visual and use a date slicer it is slicing my target value and max value in the gauge visual. I only want the slicer to filter words in progress. Can someone help explain how I can accomplish this?

Formula I'm using to get the average This is the formula I am using to calculate the target & max value in my visual

Max words (M) =
VAR Vendor = [Vendor]
RETURN
DIVIDE (
CALCULATE (
)
)

I want the value to change when I slice the date but want to keep the same value for the target and max value.

Thank you for all your help!

1 ACCEPTED SOLUTION

Accepted Solutions
Regular Visitor

## Re: Slicer filtering when it shouldn't

@v-yuta-msft

Thank you for responding to me. I was able to get the solution. I created a measure and then reference Max words (M) column.

Formula I used was

Max Words (M) Measure =
CALCULATE (
SUM ( DataDump1[Max words (M)] ),
)

And the formula I used for my calculated column to get the average of max words was

Max words (M) =
VAR Vendor = [Vendor]
RETURN
DIVIDE (
CALCULATE (
)
)

Thanks for the help and looking into it for me!

2 REPLIES 2
Community Support Team

## Re: Slicer filtering when it shouldn't

Hi jarodjp42,

Modify your measure like below and check if it can meet your requirement:

```Max words (M) =
VAR Vendor = [Vendor]
RETURN
DIVIDE (
CALCULATE (
)
)
```

Regards,

Jimmy Tao

Regular Visitor

## Re: Slicer filtering when it shouldn't

@v-yuta-msft

Thank you for responding to me. I was able to get the solution. I created a measure and then reference Max words (M) column.

Formula I used was

Max Words (M) Measure =
CALCULATE (
SUM ( DataDump1[Max words (M)] ),
)

And the formula I used for my calculated column to get the average of max words was

Max words (M) =
VAR Vendor = [Vendor]
RETURN
DIVIDE (
CALCULATE (
)
)

Thanks for the help and looking into it for me!

Announcements

#### Challenge: Can You Solve These?

Find out how to participate in the first Power BI 'Can You Solve These?' challenge.

#### Community News & Announcements

Get your latest community news and announcements.

#### Microsoft Business Applications October Virtual Launch Event

Join us for an in-depth look at the new innovations across Dynamics 365 and the Microsoft Power Platform.

#### Win Power BI Swag with Community Kudopalooza!

Each week, complete activities and be qualified in the drawing for cool Power BI Swag.

Top Kudoed Authors
Users Online
Currently online: 78 members 1,417 guests
Recent signins: