Obtaining the correct % of a column when using a slicer

[jbqrn]

Hi everyone,
I am trying to show the Nº of defficiencies (OK, KO, Pending) of a list of controls and I made the following measure: 

Defficiencies = 
DIVIDE(
CALCULATE(COUNT('Mapeo Heatmap'[Control Code]),'Mapeo Heatmap'[Rating conclusion]<>"OK" )
,

COUNT('Mapeo Heatmap'[Control Code])
)

It has to show the amount of controls that are not right, all good when using the slicer of "Control" or "Process", the problem appears when filtering with the SLICER [Rating conclusion] by KO, OK or Pending, that returns wrong data.

All Controls - correct measure 119/1848 = 6,44 % (119 no OK, 1729 OK)

OK - it has to show 0% of defficiencies - 0 controls / 1729 controls (filtered by the SLICER rating conclusion = "OK")

Pending - it has to show 100% - 31 controls "Pending"/31 controls (filtered by the SLICER rating conclusion = "PENDING")

KO - it has to show 100% - 88 controls "KO"/88 controls (filtered by the SLICER rating conclusion = "KO")

Data:

Entidad	Control Code	Rating conclusion
Corporativo	ELC-01	KO
Corporativo	ELC-02	Pending
Corporativo	ELC-03	OK
Corporativo	ELC-04	OK
Corporativo	ELC-05	OK
Corporativo	ELC-06	OK
Corporativo	ELC-07	OK
Corporativo	ELC-08	OK
Corporativo	ELC-09	OK
Corporativo	ELC-10	OK
Corporativo	ELC-11	Pending
Corporativo	ELC-12	OK
Corporativo	ELC-13	Pending

Any possible solution?

Thanks in advice!!

[SpartaBI]

@jbqrn TRY:

Defficiencies = 
DIVIDE(
CALCULATE(COUNT('Mapeo Heatmap'[Control Code]),'Mapeo Heatmap'[Rating conclusion]<>"OK" )
,

CALCULATE(COUNT('Mapeo Heatmap'[Control Code]), REMOVEFILTERS('Mapeo Heatmap'[Rating conclusion])
)

      

Showcase Report – Contoso By SpartaBI

[jbqrn]

Hi @SpartaBI, thanks for the solution!

The problem is that if I apply the remove filters argument in the division, the number that is returned doesn't change when filtering with that slicer...
😞

[SpartaBI]

@jbqrn no worries, I will PM you now