SamplePbix Uploaded filter same attribute with other slicer having same attribute

[BharathM]

Hi Everyone
Hope every one doing well. I need your help Thanks in advance

SNIP 1

Here my requirement is to filter only Delivery location and get the values as if the Base location is filtered

Eg: If i filter Del location of AKRON  i'm getting the results as below snip 

But i'm trying to acheive the values of as in below snip 

And the values should be as good as of if we filter base location i'm using Del Loction as slicer so whenever i select a specific
attribute in Del Location  it should work as if i had filtered base location

Note :i dont want add any new slicers i'm also posting the measure of distinct count used in this table

Distinctcount=

calculate(DISTINCTCOUNT('table'[DriverId]),

               GROUPBY('table','table'[BaseLocation],

                                                                    'table'[date])

                                                )     
The values I'm getting through above measure are correct 
Both Del Location and Base location are present in same table 

[tamerj1]

Hi @BharathM 
Probably @Greg_Deckler won't like this solution, I could not think of a simple no CALCULATE solution and I feel lazy as always 😅

Having one measure for both tables results in a wrong total as at the total level there is no way we can verify which column is placed in the visual therefore, I recommend splitting it into two measures following the 2nd screenshot.

[BharathM]

Hi @tamerj1  Thank you so much for replying me

Its working half of my requirement 
Here before selecting the location AKRON in the delivery location Slicer the values of baselocation are 8 

The highlighted red box values I need

After selecting the AKRON the values of AKRON are changing i'm expecting the value 8

I need the values visable in red box baselocation in above snip
After selecting also need the same values

Note: I will remove the delivery location table visual i dont want that
only the problem here is filter and the values 

[tamerj1]

@BharathM 

Try this

Distinct count =
IF (
ISFILTERED ( data3[DeliveryLocation] ),
CALCULATE (
DISTINCTCOUNT ( data3[DriverId] ),
KEEPFILTERS (
TREATAS ( VALUES ( data3[DeliveryLocation] ), data3[BaseLocation] )
),
ALLEXCEPT ( data3, data3[BaseLocation] )
),
DISTINCTCOUNT ( data3[DriverId] )
)

[BharathM]

Totals are incorrect 

I changed the measure as below and totals are correct now
Please confirm me does it cause any problem with the below measure

[tamerj1 · Accepted solution]

@BharathM 
Here are 2 solutions

[BharathM]

Hi @tamerj1 

It created one more problem for me when I'm using Drill Through of Delivery Location
AKRON in the new measure i'm not getting the values of 8 
Again I'm getting value of AKRON is 7(wrong)

without drill through when i filter in Delivery Location measure is working

It missing when using drill through

[BharathM]

@tamerj1 

I know you are brilliant Thank you so much....... It's working

[Greg_Deckler]

@BharathM Sorry, having trouble following, can you post sample data as text and expected output?
Not really enough information to go on, please first check if your issue is a common issue listed here: https://community.powerbi.com/t5/Community-Blog/Before-You-Post-Read-This/ba-p/1116882

Also, please see this post regarding How to Get Your Question Answered Quickly: https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490

The most important parts are:
1. Sample data as text, use the table tool in the editing bar
2. Expected output from sample data
3. Explanation in words of how to get from 1. to 2.

[BharathM]

Hi @Greg_Deckler @tamerj1 
Here is Sample Pbix file 

Thanks for Quick respone 

DelLocation_slicer.pbix