Forum Discussion
Clustered Bar Chart with dual Labels (Sum + Count)
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 ...
grazitti_sapna
Super User
Super UserYou 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])))