Forum Discussion

majid154a's avatar
majid154a
Icon for Helper II rankHelper II
2 years ago
Solved

Dealing with percents

I have data containing the following columns: Category, Sub-Category, Order ID, and Country. I want to visualize this data using a Matrix chart such that: - Category and Sub-Category are in the Row...
Help
  • Anonymous's avatar
    Anonymous
    2 years ago

    Hi majid154a ,

     

    Modify measure.

    MEASURE = 
VAR _count =
    COUNT ( 'Table'[Order ID] )
VAR _all =
    CALCULATE ( COUNT ( 'Table'[Order ID] ), ALLSELECTED ( 'Table'[Sub-Category]) )
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.

Anonymous's avatar
Anonymous
Not applicable
2 years ago

Source Data

Sub Category order id count formula

Count % formula

Matrix visual elements