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'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

 

 

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?

7 Replies

  • 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.

      • 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").

    • DataInsights's avatar
      DataInsights
      Super User
      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?

      • jeffjenkins's avatar
        jeffjenkins
        Frequent Visitor
        5 years ago

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

        Jeff