Latest Enterprise DNA Initiatives

Dax help needed

Hi All,

I need help in writing a DAXTesting for CPL.xlsx (17.6 KB) measure to find out the values highlighted in yellow as per the attached sheet

Regards
Kran

Hello @Nagi_k,

For the first formula

% Calcul =

VAR _TotalCTL = CALCULATE([Total CTL], ALL(Sheet1[Row Labels]))

RETURN

DIVIDE([Total CTL],_TotalCTL,0) 

For the second DAX formula I do not understand exactly what you want to compute. % over Sum CTL generic?

Calcul =

VAR _Generic = CALCULATE([Total CTL], Sheet1[Row Labels]="Generic")
VAR _Result =[%]*_Generic

RETURN _Result

Hope it helps,
Best regards

2 Likes

Thank you Alex