Clustered Bar Chart with dual Labels (Sum + Count)

[Vexorg]

Hello PowerBI Community,

I am a new user transitioning from Tableau. I have a seemingly easy task but I have been unable to figure it out.

I am trying to create a clustered bar chart which has two labels (total and count of deals). I am easily able to create the bar chart and display the totals, however I am unable to add the second label. 

PBIX here: https://www.dropbox.com/s/jd2sv8hc27ndykj/help123.pbix?dl=0

I want to include the count of commitments on each bar. The end result would be the chart below but in bar chart format:

ABC	67	2
DEF	300	1
EFG	160	3
HIJ	180	5
KLM	110	2

Here is the raw data:

Fund	Deals	Commitment
ABC	Deal A	30
ABC	Deal B	37
DEF	Deal C	300
EFG	Deal D	100
EFG	Deal E	20
EFG	Deal F	40
HIJ	Deal G	20
HIJ	Deal H	30
HIJ	Deal I	40
HIJ	Deal J	70
HIJ	Deal K	20
KLM	Deal L	50
KLM	Deal M	60

Any help would be appreciated. 

[grazitti_sapna]

You can create a summarized table with the following formula:

Summarize Table = SUMMARIZE(ALL(Funds), Funds[Fund],"Count",CALCULATE(DISTINCTCOUNTNOBLANK(Funds[Deals]),ALLEXCEPT(Funds,Funds[Fund])),"Sum",CALCULATE(SUM(Funds[Commitment]),ALLEXCEPT(Funds,Funds[Fund])))

[Arul]

@Vexorg ,

You can have only one either of sum of commitment of the count of deals in Y-axis if you are adding Fund in the legend field but if you removes the legend you are able to add as many as measure values in the Y-axis.
If you need legend then you are allowed to have only one measure value in Y-axis, so you can make use of tooltip option to show the count.

Thanks,

Arul

[Tahreem24]

@Vexorg  First of all welcome to this community.
On your query, You can add fields in tooltip section of any chart. Attaching screen shot for your reference.