How to show the client with the most cancelled contracts

[tspek]

Ok so i have 3 columns: contracts, client and status

contracts is a list of contractnumbers

client is the one that "owns" the contract. like if a client wants to buy something a contract is being made

status is either: cancelled, order or option. These are writen as text. 

i want to make a chart where i can show which client has the most cancelled contracts but I can't figure it out.

Any help is appreciated 

Thijn

[Zubair_Muhammad · Accepted solution]

@tspek

Try creating a MEASURE like

Count of Cancelled contracts =
CALCULATE ( COUNT ( TableName[Contracts] ), TableName[Status] = "Cancelled" )

Then put "Client" column in X-Axis and "Measure" in Values in a chart.........and sort by MEASURE

[tspek]

Thank you! this is exactly what I needed.

Do you have any tips on how/where to learn the functions?

this would make PBI much easier

[Zubair_Muhammad]

@tspek

Hi,

Please check the link below

Microsoft Power BI Guided Learning

Also following books are great for learning

• Building Data Models With Power Pivot

• Power Pivot and Power BI: The Excel User’s Guide to DAX, Power Query, Power BI & Power Pivot in Exce...

• Learn to Write DAX: A practical guide to learning Power Pivot for Excel and Power BI

• M Is for (Data) Monkey: A Guide to the M Language in Excel Power Query

• The Definitive Guide to DAX

Also followig websites have quality learning material

www.powerpivotpro.com

www.daxpatterns.com

www.sqlbi.com

www.excelguru.ca