Divide matrix row value with a fixed value

[BYENER]

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.

[Mariusz · Accepted solution]

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]

Hi @BYENER 

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

Best Regards,
Mariusz

If this post helps, then please consider Accepting it as the solution.

[BYENER]

@Mariusz 

Still not working 🤔

[Mariusz]

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]

@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 · Accepted solution]

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]

@Mariusz thanks a lot! It's working and I am happy 🙂

[BYENER]

@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 · Accepted solution]

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]

@Mariusz this is also working! Thanks a lot.

[v-lionel-msft]

Hi @BYENER ,

If it is sloved, could you kindly accept it as a solution to close this case?

Best Regards,
Lionel Chen

[amitchandak]

If possible please share a sample pbix file after removing sensitive information.Thanks.

My Recent Blog -

https://community.powerbi.com/t5/Community-Blog/HR-Analytics-Active-Employee-Hire-and-Termination-tr...