PowerBi Visual help

[DJFANDANGO]

Hi,

Looking for my visual to show the percentage of the particular permit audited, not the percentage of 'all' permits.

Audit requirements:
Cold Work 10%
Hot Work 20%
Confined Space Entry 100%

Measure:
% Inspected = DIVIDE([Audited Cnt],[All Permits],0)

Added Table: Permit Type

Is there a way of getting this to show what i need, hope it makes sense?

Cheers

 

[DJFANDANGO]

Reference Id	Is Domestic	Date Permit Authorized	Permit Type																																			Permit Audited	Department
			Confined Space Entry																																			TRUE
			Hot Works																																			TRUE
			Hot Works																																			TRUE
			Hot Works																																			TRUE
			Hot Works																																			TRUE
			Hot Works																																			TRUE
			Hot Works																																			TRUE
			Confined Space Entry																																			TRUE
			Cold Work																																			TRUE
			Cold Work																																			FALSE
			Cold Work																																			FALSE
			Cold Work																																			FALSE
			Cold Work																																			FALSE
			Cold Work																																			FALSE
			Cold Work																																			TRUE
			Cold Work																																			FALSE
			Cold Work																																			FALSE
			Cold Work																																			FALSE
			Hot Works																																			TRUE
			Hot Works																																			FALSE
			Cold Work																																			FALSE
			Cold Work																																			FALSE
			Hot Works																																			FALSE
			Hot Works																																			FALSE
			Cold Work																																			FALSE
			Cold Work																																			FALSE

 

[RoryA]

Do you have a measure that returns the number of items for that permit, rather than the count of all items, which is what I assume [All Permits] returns?

 

[DJFANDANGO]

Yes,
But I don't use it in this visual...

All Permits = CALCULATE(COUNTROWS('Sheet1'),ALLEXCEPT('Sheet1','Sheet1'[Permit Type]))

 

[RoryA]

All Permits appears to be the count for a particular permit type then (somewhat misleading name), not all permits. I don't think I follow what it is you want to display.