Forum Discussion

AndyDD_UK's avatar
AndyDD_UK
Icon for Helper III rankHelper III
3 years ago

Help with DAX

In my Cube table I have a table showing employee and the number of hours they have submitted late in their timesheets by week.   For example, if I filter for all the weeks in Feb 2023 I can see tha...
AndyDD_UK's avatar
AndyDD_UK
Icon for Helper III rankHelper III
3 years ago

Sorry...compliance is whether they are late or not...all the data required is in the one table called EMPL in the Cube...

 

In EMPL you have week....and in DimDate Table there is week and month

 

Thanks again

 

 

 

 

tamerj1's avatar
tamerj1
Icon for Community Champion rankCommunity Champion
3 years ago

AndyDD_UK 
The compliance column must not be in the matrix as calculated columns are not dynamic, rather they're calculated once when you refresh the pbix file. 
The very first DAX I shared with you is a measure not a calculated column. And I'm pretty sure that once placed in the values of the matrix, it should work just fine at both week level and month level.

Compliance Mesure = 
IF ( SUM ( 'EMPL'[Late_hours] ) = 0, "Not Late", "Late" )