CALCULATE DIFFERENT WITH TWO FILTERS

[Syndicate_Admin]

Good afternoon

I'm stuck to make this formula. What I need is a different count of dates, but one that takes into account both the month and the id.

That is, in month 7, the 100 employee has been there for 3 days.

Would there be any way to put this double filter?.

It will make you catch the month filter:

Daily cost July = CALCULATE (

DISTINCTCOUNT ( 'Production Data: Capacity Hours (Antonio)'[DAY] ),

FILTER (

ALLSELECTED ( 'Production Data: Capacity Hours (Antonio)' ),

'Production Data: Capacity Hours (Antonio)'[MO] = 6 ))

But for the employee filter, you have to depend on each employee, not do a =100 (for example)

In other words, I don't want to:

CALCULATE (

DISTINCTCOUNT ( 'Production Data: Capacity Hours (Antonio)'[DAY]),

FILTER (

ALLSELECTED ( 'Production Data: Capacity Hours (Antonio)' ),

'Data Production: Hours Capacity (Antonio)'[MES] = 7 &&'Data Production: Hours Capacity (Antonio)'[SAP ID]=100))

Because I want the data that comes out in the column to depend on the ID

[DataInsights · Accepted solution]

@josefmc08,

Try this measure:

RESULTADO CONTAR DISTINTO = 
CALCULATE (
    DISTINCTCOUNT ( 'Production Data: Capacity Hours (Antonio)'[DAY] ),
    ALLEXCEPT (
        'Production Data: Capacity Hours (Antonio)',
        'Production Data: Capacity Hours (Antonio)'[ID],
        'Production Data: Capacity Hours (Antonio)'[MO]
    )
)

[DataInsights · Accepted solution]

@josefmc08,

Try this measure:

RESULTADO CONTAR DISTINTO = 
CALCULATE (
    DISTINCTCOUNT ( 'Production Data: Capacity Hours (Antonio)'[DAY] ),
    ALLEXCEPT (
        'Production Data: Capacity Hours (Antonio)',
        'Production Data: Capacity Hours (Antonio)'[ID],
        'Production Data: Capacity Hours (Antonio)'[MO]
    )
)

[Syndicate_Admin · Accepted solution]

That's great!!!

It works perfect. Thanks a lot!