Create a Calculated column for Matrix visual

[Anonymous]

Hi guys,

I wonder if it is possible or not, so please help to confirm 

I have a data set like that :

After using Matrix, I have a result like that:

I would like to create a calculated column like below for the Matrix, is that possible?

Could you please help me? Thank you in advance

[v-piga-msft · Accepted solution]

Hi @Anonymous ,

For your requirement, I'm afraid that we should create measure to achieve your desired output.

Measure =
VAR day =
    CALCULATE ( SUM ( 'Table'[Hours(Day)] ) )
VAR night =
    CALCULATE ( SUM ( 'Table'[Hours(Night)] ) )
RETURN
    DIVIDE ( day, day + night )

Here is the output. As you can see, if we create the calculated column, the total row will be incorrect.

Hope this can help you.

Best  Regards,

Cherry