cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted

Measure ignore slicer filter

I'm trying to create a measure that shows the the total number of days applied by a date filter (to use as a denominator in other measures).  The fact table doesn't necessarily have contiguos dates at the required granulairty so I used the Date table dates.  The measure returns the correct result when visualised alone, but when I add the measure to a table visualistaion it ignores filtering applied on it by a slicer

 

The measure is...

 

Total Days = DISTINCTCOUNT('Date'[Date])

 

My data is a star schema of 4 table : a Sales Fact + Product, Store, and Date dimensions. There is a 1:M relationship between each dimension and the fact table

 

The table visualisation has

'Product'[Name]

'Measures'[Sales]

'Measures'[Total Days]

With a 'Store'[Name] slicer and a 'Date'[Date] page level filter

 

 

 

 

 

 

2 REPLIES 2
BILASolution Established Member
Established Member

Re: Measure ignore slicer filter

Hi @edwardrmiles

 

Change the "Cross filter direction" in the relationship to "Both" (for Product and Sales Fact table).

 

x.png

 

 

I hope this helps

 

BILASolution

Re: Measure ignore slicer filter

Thanks @BILASolution that does work, but I ommited to mention that I'd like to introduce a second fact table to the model, so the dimensions will have realtionships to both fact tables.  Bi directional relationships don't work propertly with conformed dimensions. Ideally I'm looking for a DAX solution

Helpful resources

Announcements
October 2019 Community Highlights

October 2019 Community Highlights

October was a busy month in the community. Read the recap article to learn about some of the events and content.

New Solution Badges

New Solution Badges

Two waves of brand new solution badges are coming! Read the article for more information on our new community badges.

Ask Amir Anything

Exclusive LIVE Community Event No. 2 – Ask Amir Anything

Next in our Triple A series: Ask Amir Netz questions about the latest updates, features and future.

Analytics in Azure virtual event

Analytics in Azure virtual event

Experience a limitless analytics service built to ingest, prep, manage, and serve data for immediate use in Power BI.

Users Online
Currently online: 175 members 2,098 guests
Please welcome our newest community members: