Forum Discussion

BYENER's avatar
BYENER
Helper 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
Community Champion
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.

 

BYENER's avatar
BYENER
Helper V
6 years ago

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

  • v-lionel-msft's avatar
    v-lionel-msft
    Community Support
    6 years ago

    Hi BYENER ,

    If it is sloved, could you kindly accept it as a solution to close this case?


    Best Regards,
    Lionel Chen

     

  • BYENER's avatar
    BYENER
    Helper 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
      Community 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
        Helper V
        6 years ago

        Mariusz this is also working! Thanks a lot.