Forum Discussion

FM-Rad10's avatar
FM-Rad10
Frequent Visitor
1 year ago
Solved

% Calculation within Group.

  I have the following Matrix Colour Model Count of Key % Blue XX1 3407 81.31% Blue XX2 38856 72.33% Red XX1 472 11.26% Red XX2 9570 17.81% Green XX1 311 7.42% ...
Need Help
  • FM-Rad10's avatar
    FM-Rad10
    1 year ago

    I found the solution after a lot of trial and error. 

     

    DIVIDE(
    [Value],
    CALCULATE(
        [Value],
        ALLSELECTED('Table'),
        VALUES('Table'[Model])
    )
)
FM-Rad10's avatar
FM-Rad10
Frequent Visitor
1 year ago

I found the solution after a lot of trial and error. 

 

DIVIDE(
    [Value],
    CALCULATE(
        [Value],
        ALLSELECTED('Table'),
        VALUES('Table'[Model])
    )
)