Problem with Percent calculation

[anouar]

I'm strugling with DAX, I have been trying to create a New Column that

1. calculates the faulty equipment:
2. calculates the percentage number of faulty location

I have been using unsucessfully trying

1. CALCULATE(COUNTROWS(FILTER('equipments','equipments'[Error]='true')))  --> should be 3
   
2. CALCULATE(COUNTX(FILTER('equipments','equipments'[Error]='true'), 'equipments'[Location]) / COUNT('equipments'[Location]))  --> should be 80 %
   

for more info, here ist the subset of the tabel equipments:

Any help is greatly appreciated. 

[Greg_Deckler]

First, from your data, I believe that you have 4 "true" values, not 3.

You should be able to simply create a table where you put "Error" and the Equipment and then change Equipment to be "Count of Equipment" from the drop-down for the field in the Visualizations pane.

Similarly, you could create a table and put Error into it and then put Location as well and then swithc Location to be "Count of Location" and then change the "Show value as" to "Percent of grand total".