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 

 

Try  / CALCULATE( [Measure], ALL( table[Category] ) )

 

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 not working ğŸ¤”

    • Mariusz's avatar
      Mariusz
      Community Champion
      6 years ago

      Hi BYENER 

       

      How about Try  / CALCULATE( [Measure], ALL( your table ) ) 

       

       

      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.