Forum Discussion
Help on Context filter
Hello, I'm migrating the Tableau dashboard to Power BI, data does not seem to match for the same period. After some digging in the Tableau dashboard, I found there were 13 unique EMP IDs but in ...
Did you mean to include the 'Final Table'[Time Range] inside ALLEXCEPT() rather than as a seperate filter? You could try:
Global Condition-Hours = CALCULATE(SUM('Final Table'[Total Hours]), ALLEXCEPT('Final Table','Final Table'[Emp Id],'Final Table'[Time Range]))>=1600
Thanks for the reply, I tried your solution but it has no affect on the visual the result is the same. I wanted to know why I cannot use time period as a context filter