Dealing with percents

Percentages in Power BI are achieved obviously with the division of a numerator by a denominator.

The DIVIDE function is key, but the harder part (as least as i've been learning) in Power BI is understanding a concept called filter context - basically how the tables are populated. For the denominator to work correctly as you want you'll need to remove filters being applied to the numerator. Which filters depend on what you want to divide by. This will be acheived using the REMOVEFILTERS function.

This will likley involve removing the filters that apply to country (to give a total of all the orders across countries) and removing the filters on subcategory. To get each one to add up to 100%, probably need to use two different measures.

Here's a really helpful video explaining filter context from the nice people as SQLBI:

https://www.youtube.com/watch?v=L5WR-imfyYI 

Hope that helps point you in the right direction.

Adam

Source Data

Sub Category order id count formula

Count % formula

Matrix visual elements

Hi majid154a ,

Thanks for the reply from Anonymous  and BINewbie1 , please allow me to provide another insight:

You can try this measure expression.

MEASURE = 
VAR _count =
    COUNT ( 'Table'[Order ID] )
VAR _all =
    CALCULATE ( COUNT ( 'Table'[Order ID] ), ALLSELECTED ( 'Table' ) )
RETURN
    DIVIDE ( _count, _all )

If your Current Period does not refer to this, please clarify in a follow-up reply.

Best Regards,

Clara Gong

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.