Forum Discussion
multiple filters without cross interaction
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?
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?
Just tested...Yes! Both fields are coming out with the desired median values. Thank you so much!
Jeff