Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

Need help

Hi, I'm trying to show values in clustered column chart in the below manner.     My client wants to see 100% for each Market listed in the chart instead of showing 100% for all markets. T...
Need Help
  • v-zhangti's avatar
    v-zhangti
    4 years ago

    Hi, Anonymous 

     

    I briefly simulated some data to hopefully fit your needs.

    Measure:

    Percentage =
DIVIDE (
    CALCULATE (
        COUNT ( 'Table'[Emp ID] ),
        FILTER (
            ALL ( 'Table' ),
            [Market] = SELECTEDVALUE ( 'Table'[Market] )
                && [Emp ID] = SELECTEDVALUE ( 'Table'[Emp ID] )
        )
    ),
    CALCULATE (
        COUNT ( 'Table'[Emp ID] ),
        FILTER ( ALL ( 'Table' ), [Market] = SELECTEDVALUE ( 'Table'[Market] ) )
    )
)

    Is this the result you expect, showing 100% by each market?

     

    Best Regards,

    Community Support Team _Charlotte

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

amitchandak's avatar
amitchandak
Super User
4 years ago

Anonymous , a new Measure

 

assume you have measure for which you want this %

 

divide([measure], calculate([measure], removefilters(Table[Legend Column]))

 

Use the legend column in remove filters

  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

    amitchandak there's no measure created for this. We're showing the % of grand total in the chart