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 

 

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.