Forum Discussion

paul_marcault's avatar
paul_marcault
Frequent Visitor
4 years ago

YEAR Segment Filter not working as expected when a particular measure is in the visual

Hi everyone, 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]) Cumul =    V...
Need Help
Anonymous's avatar
Anonymous
Not applicable
4 years ago

Hi paul_marcault ,

 

Looks like CurrentTotal in second measure will also be filtered by allselected() function, you could take a check.

 

Best Regards,

Jay

paul_marcault's avatar
paul_marcault
Frequent Visitor
4 years ago

Hi Jay, thanks for your reply. (you can play with the file which I made available for download)
To reply to your point: If CurrentTotal was applied ALLSELECTED, then the Cumul calculation would be wrong (it would be constant for each row and equal to the Sum of all OrderValue
and CurrentTotal is set to VAR outside the iteration where ALLSELECTED is used in FILTER(ALLSELECTED(OrderBook[Supplier]). But here the Cumul calculation are correct.

Just look at the difference when you use only the visual filter OrderDate=10/03/2022 and 15/08/2022
and compare when you use only the visual filter YEAR=2022. We shall expect the same results .
The case is so simple, but so strange indeed.