Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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=
Solved! Go to Solution.
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.
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
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] )
)
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
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 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.
Hi @Greg_Deckler @tamerj1
Here is Sample Pbix file
Thanks for Quick respone
DelLocation_slicer.pbix
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
49 | |
25 | |
20 | |
15 | |
12 |
User | Count |
---|---|
57 | |
49 | |
44 | |
18 | |
18 |