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

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.

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

    Thank you for helping Anonymous 

    In the image below, I need the red circle to represent 100%. Additionally, I need each yellow circle to also represent 100%.

    How can we achieve this?

     

    • Anonymous's avatar
      Anonymous
      Not applicable
      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.