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.
BYENER's avatar
BYENER
Icon for Helper V rankHelper V
6 years ago

Mariusz thanks a lot! It's working and I am happy 🙂

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

Mariusz one more question, when I select multiple weeks then it are dividing by the total number of the selected weeks. It have to be divide by the total number per week, because the columns in the matrix are split in weeks.

 

For example: total number of week 52 = 14358 , but it's dividing by 1.353.683 because all weeks are selected.

 

 

  • 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.