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 in categories, but I don’t want that. See below for an example:

 

Expected situation:

 

Category, Count of serial number, % of Measure

A , 20 , 20 / (500) measure

B, 50 , 20 / (500) measure

C, 1, 20 / (500) measure

D, 60, 20 / (500) measure

 

Current situation: Measure = 500

 

Category, Count of serial number, % of Measure

A , 20 , 20 / (30) measure

B, 50 , 20 / (150) measure

C, 1, 20 / (100) measure

D, 60, 20 / (220) measure

 
Thanks in advance.
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.

11 Replies

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

     

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