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

Thanks tried that as a calculated column and it's still at row level. 

 

My visual is a matrix. Column A is "Compliance', Column B is employee name and columns are months/weeks. 

 

If I create calculation as DAX measure I can't show it in Column A. Thanks, hope you can help?

 

 

 

 

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

AndyDD_UK 

What is compliance? Are week and month from the same table for from a connected dimDate table?

  • 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" )