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