Showing results for 
Search instead for 
Did you mean: 

Fabric is Generally Available. Browse Fabric Presentations. Work towards your Fabric certification with the Cloud Skills Challenge.

Not applicable

Measure behaving Errounous with Hierarchy Slicer and ALL filter


I'm having a Measure with this formula. (This would become a Rolling/Moving Average)


There is a relation between FACT_TICKET_V2 and Calendar based on the Field ADATE.

In Calendar I have a Hierachy Year, YearMonth, ADATE.

When displaying a given date with a normal slicer and selecting a date i'm getting a different value then when selecting the same date in the Hierarchy.


Solution Sage
Solution Sage

Hi @Anonymous,


Could you please share us your pbix file with One Drive or Google Drive if possible? So that I can dig deeper and make some tests. Otherwise with current information it is hard to say where the issue is.


Xi Jin.

Not applicable

I've created a local version but that one doesn't produce the error/behaviour. My original pbix connects to a Azure SSAS.

The funny thing is that it is only on some days, quite strange.

The local model loaded from CSV files works perfectly....

Not applicable

2018-05-10 22_52_12-HL On Beta v00 - Power BI Desktop.png2018-05-10 22_52_36-HL On Beta v00 - Power BI Desktop.png

Helpful resources

PBI November 2023 Update Carousel

Power BI Monthly Update - November 2023

Check out the November 2023 Power BI update to learn about new features.

Power BI Fabric Summit Carousel

The largest Power BI and Fabric virtual conference

130+ sessions, 130+ speakers, Product managers, MVPs, and experts. All about Power BI and Fabric. Attend online or watch the recordings.

Top Solution Authors
Top Kudoed Authors