Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

Display multiple repeat data values as a count in a visual

Hi,   I am quite new to Power BI and am having a real head-scratcher at the moment trying to get a visual to illustrate how may times a list of employees have been given an award.   The data-set ...
  • v-jiascu-msft's avatar
    v-jiascu-msft
    7 years ago

    Hi Anonymous,

     

    I would suggest you create a calculated table. One stone two birds.

    Table =
SUMMARIZE ( 'Table1', 'Table1'[Name], "times", COUNT ( Table1[Name] ) )

    Display_multiple_repeat_data_values_as_a_count_in_a_visual

     

    Best Regards,

    Dale

v-jiascu-msft's avatar
v-jiascu-msft
Microsoft Employee
7 years ago

Hi Anonymous,

 

I would suggest you create a calculated table. One stone two birds.

Table =
SUMMARIZE ( 'Table1', 'Table1'[Name], "times", COUNT ( Table1[Name] ) )

Display_multiple_repeat_data_values_as_a_count_in_a_visual

 

Best Regards,

Dale

Anonymous's avatar
Anonymous
Not applicable
7 years ago

Thank you!