how to calculate and show proportion of items in a category

[OPS-MLTSD]

hello,

I have a table that looks similar to this 

client ID	category	event
123456	employment	resume help
1234534	employment	career advice
2345	housing	mortgage help
23935	finance	budget help
123874	creative	writers block

I am tyring to create a visual that shows the proprotion of clients attending an event per category (so I would like to show the percentage) how can I achieve that?

I created a decomposition tree but I only want to show in a visual the part I have in the black box. How can I do that? Basically, I don't want the category or %count of client ID to show but I want the data from the event to show

If someone could please tell me how I can create a measure, that would be great

[v-yangliu-msft]

Hi  @OPS-MLTSD ,

Here are the steps you can follow：

You can use the If function to display the data you want

For example, my picture is shown as:

Custom rules, do not want to display career advice and resume help in column [event], 23935 in column [client ID]

1. Create measure.

Measure =
IF( MAX('Table'[event]) in {"career advice","resume help"}||MAX('Table'[client ID] )= 23935,0,1)

2. Place the measure in Filters, set is =1, apply filter.

3. Result:

Will only show the data you need

Best Regards,

Liu Yang

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

[OPS-MLTSD]

thank you, I have 20,000 clients in total in my table, and under the category "employment", there are 88 events, is ther a way to create the mesure so that I don't have to type each event name and client ID into the measure?

The clients can attend more than one event - so for example client ID # 23935 has attended 7 different events under the categories employment and housing.

Thank you once again

[amitchandak]

@OPS-MLTSD , Stacked visual or Sankey visual, you can try for this ?

[OPS-MLTSD]

thanks, is there a measure I can create to calculate the proportion? Because that's what I need