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

  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

    Hi v-zhangti ,

     

    As you can see in the picture I posted in my message, I'm % of emps in each market. I didn't create any measure for this. I used the count of emps and showed the value as %GT of Emps on the chart.

     

    The new requirement is that I need to show % of emps as 100% for each market instead of segregating the total value across markets.

     

    Below is a measure that can help me do that but I'm looking for something more dynamic which can be used for all markets in a single measure.

     

    Buildings = calculate( Count(Emp ID), Market = "Buildings")

    Please let me know if we have a way to do this calculation for all markets in a dynamic way.

     

    Regards,

    Mahesh

    • v-zhangti's avatar
      v-zhangti
      Community Support
      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.