Forum Discussion

apai1990's avatar
apai1990
Frequent Visitor
2 years ago

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 ...
Need Help
Tips and Tricks
halfglassdarkly's avatar
halfglassdarkly
Responsive Resident
2 years ago

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

apai1990's avatar
apai1990
Frequent Visitor
2 years ago

I tried using time rage in ALLEXCEPT like this:

Global working hours= CALCULATE(SUM(table[working hours]), ALLEXCEPT(table, table[Emp Id], table[time range]))>=1600

 

But the result is blank, I know that the Power BI is calculating it on each time range. Which is cumulatively less than 1600. The problem is my time range is like 202201 where synatx is year+weeknum. I'm using it as a filter range means between the range I need my EMP ID count which will be used to calculate Avg. Pay

I think I need to devote more time to this problem...