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.

v-zhangti's avatar
v-zhangti
Community Support
4 years ago

Hi, Anonymous 

 

Can you provide some of the example data for testing? What do you expect the results to look like, and can you also show them in pictures?

 

Best Regards