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

Mariusz , still the same issue. Maybe it's more clear when I show some screenshots.

 

The Card visual is the total processed volume in week 52 for origin "NL". This measure is based on the "screening" table. The matrix "category" is based on the "WIP" table. The Measure column have to show the same number as the card visual.

 

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.