I found some unexpected results using a YEAR filter in a very simple case. Here is the data table:
I defined 2 measures :
Total_Order = SUM(OrderBook[OrderValue])
VAR CurrentTotal = SUM(OrderBook[OrderValue])
FILTER(ALLSELECTED(OrderBook[Supplier]), CALCULATE(SUM(OrderBook[OrderValue])) >= CurrentTotal))
Time Intelligence Auto Date/Time : is ACTIVATED (per default, on global and current file), allowing to use YEAR from date hierarchy.
Using the date visual filters :
With OrderDate=10/03/2022 and 15/08/2022 as expected, 2 rows
With Year=2022, it shows 4 rows, which is not what I expected (I expected only the 2 rows of 2022, so corresponding to supplier1 and supplier2). So strange !
But removing the measure "Cumul" from the visual, working as expected: 2 rows (behaving the same with either OrderDate or Year filter)
DOWNLOAD here: Exemple CUMUL RANKX - 1.pbix
What is wrong ? Is there something with the measure "Cumul" or some PBI parameters which I am unaware of ?
Thanks for your lights.