Forum Discussion

jeffjenkins's avatar
jeffjenkins
Frequent Visitor
5 years ago
Solved

multiple filters without cross interaction

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'...
Need Help
  • DataInsights's avatar
    DataInsights
    5 years ago

    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?

DataInsights's avatar
DataInsights
Super User
5 years ago

jeffjenkins,

 

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