all on facts table vs without all output

[san17680]

hello team,

i am just wondering why these two produce different results

fact sales filter all = CALCULATE(COUNTROWS('Calendar'),ALL(Sales_data)): output 1461 rows

fact sales filter = CALCULATE(COUNTROWS('Calendar'),Sales_data) : output 1081 rows

[Idrissshatila · Accepted solution]

Hello @san17680 ,

The "All" function remove all filters applied on table, so if there's any applied filters it won't take it into consideration, so the difference is that there might be a filter in the report that's filtering the second measure.

If I answered your question, please mark my post as solution, Appreciate your Kudos 👍

Follow me on Linkedin
Vote For my Idea💡