Forum Discussion

Geraldtanwx199_'s avatar
Geraldtanwx199_
New Member
1 year ago
Solved

How do I get the breakdown by percent?

 Is there a way to break down using measures?

I am using a matrix 

Need Help
Show and Tell
  • Anonymous's avatar
    Anonymous
    1 year ago

    Hi Geraldtanwx199_ ,

     

    You can refer to this example below.


    This is the original data.

     

    Create measure and select the percentage style.

    MEASURE =
VAR _sum1 =
CALCULATE (
SUM ( financials[ Sales] ),
FILTER (
ALL ( financials ),
'financials'[Country] = MAX ( 'financials'[Country] )
)
)
VAR _sum2 =
SUM ( financials[ Sales] )
RETURN
DIVIDE ( _sum2, _sum1 )

     

    The final result is shown below. More detailed information can be found in the attachment.

     

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

     

    Best Regards,

    Clara Gong

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

3 Replies

  • SamWiseOwl's avatar
    SamWiseOwl
    Icon for Super User rankSuper User
    1 year ago

    Hi Geraldtanwx199_ 

    Go to the field in the visualisation pane, click the arrow by the field and choose show value as Perecentage

     

  • ThomasWeppler's avatar
    ThomasWeppler
    Icon for Impactful Individual rankImpactful Individual
    1 year ago

    breakdown by percent =
    DIVIDE (
    [sum of frequency],
    CALCULATE ( ALL ( [sum of frequency] ) ),
    BLANK ()
    )

    Try this. 🙂

     

    I hope this solves your problem 🙂

  • Anonymous's avatar
    Anonymous
    Not applicable
    1 year ago

    Hi Geraldtanwx199_ ,

     

    You can refer to this example below.


    This is the original data.

     

    Create measure and select the percentage style.

    MEASURE =
VAR _sum1 =
CALCULATE (
SUM ( financials[ Sales] ),
FILTER (
ALL ( financials ),
'financials'[Country] = MAX ( 'financials'[Country] )
)
)
VAR _sum2 =
SUM ( financials[ Sales] )
RETURN
DIVIDE ( _sum2, _sum1 )

     

    The final result is shown below. More detailed information can be found in the attachment.

     

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

     

    Best Regards,

    Clara Gong

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