multiple filters without cross interaction

[jeffjenkins]

Hi - trying to calculate medians for one category of data in a single location & in all location (why can't I include a pbix here?).  Screenshot not super helpful probably. my data has 4 columns & I've created one measure to get FleetMedian:  

FltMdnDuration = CALCULATE(MEDIAN(dummydata[duration]), ALL(dummydata[sitekey]), FILTER(dummydata, dummydata[duration]>0))

   The FleetMedian card should not change value as different sitekeys are selected in the filter...but it is changing.  I also want to exclude zero's in the data;  when I put a filter on the page duration > 0...it causes the FltMedian card to display the same value as the card showing value for one sitekey.  Some kind of interaction going on between the filters that I'm not getting them to operate as I hope.  

Anyone familiar with what is going on?  Any way I can post a sample pbix?

Thanks,  Jeff

[jeffjenkins]

https://mybpl-my.sharepoint.com/:u:/g/personal/jeff_jenkins_bplgroup_com/EZ1EZltuiotFtjMNtYlpFvIBh6L... 

[DataInsights · Accepted solution]

@jeffjenkins,

I modified your measure [FltMdnDuration] with regard to the last argument. Instead of using FILTER for the entire table, it now filters only [duration].

FltMdnDuration = 
CALCULATE (
    MEDIAN ( dummydata[duration] ),
    ALL ( dummydata[sitekey] ),
    dummydata[duration] > 0
)

It's best practice to use explicit measures, so I changed Median of Duration to a measure instead of using Median in the field dropdown.

Median of Duration = MEDIAN ( dummydata[duration] )

When I put these two measures into a visual with interactions enabled for both slicers, I get this:

Is this correct?

[jeffjenkins]

Just tested...Yes!  Both fields are coming out with the desired median values.  Thank you so much!

Jeff

[DataInsights]

@jeffjenkins,

You can disable interactions between visuals in Format --> Edit interactions:

You can share a pbix link (OneDrive, etc.).

[jeffjenkins]

Thanks!  I just added a link to an example pbix;  hope my work onenote allows access.

The pbix (and screenshot of it) use cards to display the 2 different median measurements...but really both numbers will be used in one visual (probably a bullet chart).  With both measures in one visual, I can't break the link with the filters.

[DataInsights]

@jeffjenkins,

I wasn't able to access the pbix ("<email address> can't be found in the mybpl-my.sharepoint.com directory").

[jeffjenkins]

maybe my google drive will work (if you still have time to look at it):

https://drive.google.com/file/d/19ETvTvOkCLqPaJqYgF5pqQIQL0RTApoB/view?usp=sharing