Summarizecolumns with Distinctcount and filter

[Anonymous]

Hi everyone!

I want to create a table from another one with SUMMARIZECOLUMNS.

Summary Table =

SUMMARIZECOLUMNS (

'Check-List Bayer / Autoelevador'[Campo de fecha del formulario],

"Maquinas por día", DISTINCTCOUNT('Check-List Bayer / Autoelevador'[Equipo]))

Now I have to make the DISTINCTCOUNT from the Equipo column but i need to exclude some values : "Eléctrica 1", "Eléctrica 2", "Eléctrica 3", "Eléctrica 4".

I tried adding a filter but the function does not work.

Does anyone have an idea?

Thanks a lot!

Jean-Ri

[amitchandak · Accepted solution]

@Anonymous , Try like

Summary Table =
SUMMARIZECOLUMNS (
'Check-List Bayer / Autoelevador'[Campo de fecha del formulario],
"Maquinas por día",
calculate(DISTINCTCOUNT('Check-List Bayer / Autoelevador'[Equipo]), filter('Check-List Bayer / Autoelevador', not( 'Check-List Bayer / Autoelevador'[Equipo] in { "Eléctrica 1", "Eléctrica 2", "Eléctrica 3", "Eléctrica 4"}))) )

[Anonymous]

@amitchandak, So I tried reformatting yours to work with mine and I'm getting a "THe expression refers to multiple columns. Multiple columns cannot be converted t a scalar value"

Any ideas waht that means?

SUMMARIZECOLUMNS (

'DTS_BII_Fact_Stops'[StopArrivalDate],

"Tractors",

calculate(DISTINCTCOUNT('DTS_BII_Fact_Stops'[TractorID]), filter('DTS_BII_Fact_Stops', ( 'DTS_BII_Fact_Stops'[ResourceType] in { "Fixed"}))) )