Microsoft Power BI Guided Learning

tspek · ‎07-18-2018

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 · ‎07-18-2018

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

Regards
Zubair

Please try my custom visuals

Zubair_Muhammad · ‎07-18-2018

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

Regards
Zubair

Please try my custom visuals

tspek · ‎07-18-2018

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 · ‎07-18-2018

Hi,

Please check the link below

Also following books are great for learning

Also followig websites have quality learning material

Regards
Zubair

Please try my custom visuals

How to show the client with the most cancelled contracts