Forum Discussion

BYENER's avatar
BYENER
Icon for Helper V rankHelper V
6 years ago
Solved

Divide matrix row value with a fixed value

Hi,   Can someone help me with the following issue: I am using a matrix visual and I want to divide the row values with a fixed value (measure). At the moment the measure value is also splitting i...
Need Help
  • Mariusz's avatar
    Mariusz
    6 years ago

    Hi BYENER

     

    This should work.

    Measure = 
CALCULATE(
    [Screening Volume],
    ALLSELECTED()
)

     

    Best Regards,
    Mariusz

    If this post helps, then please consider Accepting it as the solution.

     

  • Mariusz's avatar
    Mariusz
    6 years ago

    Hi BYENER 

     

    You can try something like.

    % Sales = 
DIVIDE(
    [Sales],
    CALCULATE(
        [Sales],
        ALLSELECTED(),
        VALUES( 'Calendar'[Year Week] )
    )
)

     

    Best Regards,
    Mariusz

    If this post helps, then please consider Accepting it as the solution.
Mariusz's avatar
Mariusz
Icon for Community Champion rankCommunity Champion
6 years ago

Hi BYENER 

 

You can try something like.

% Sales = 
DIVIDE(
    [Sales],
    CALCULATE(
        [Sales],
        ALLSELECTED(),
        VALUES( 'Calendar'[Year Week] )
    )
)

 

Best Regards,
Mariusz

If this post helps, then please consider Accepting it as the solution.
BYENER's avatar
BYENER
Icon for Helper V rankHelper V
6 years ago

Mariusz this is also working! Thanks a lot.