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,

 

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

 

 

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

jeffjenkins's avatar
jeffjenkins
Frequent Visitor
5 years ago

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.