Distinctcount with COUNTROWS

Hi Ley ,

Please update your formula like that.

Measure = 
VAR dis =
    CALCULATE (
        DISTINCTCOUNT ( Historico[ID de incidencia] ),
        FILTER (
            Historico,
            Historico[Anomalia3] = "Anomalia3"
                && Historico[EmpresaSopInicial] = "ViewNext"
        )
    )
RETURN
    CALCULATE ( COUNTROWS ( Historico ), FILTER ( Historico, dis > 3 ) )

If it doesn't meet your requirement,  kindly share your sample data and excepted result to me if you don't have any Confidential Information. Please upload your files to One Drive and share the link here.

Hi,

I have tryed your formula and it does not work. I want a distinctcount of ID when the number of rows associated with this ID that meet the conditions are superior to 3. I have tried the following modification of your formula, but I am not sure if it is right.

Thanks in advance

Hi Ley ,

Kindly share your sample data and excepted result to me if you don't have any Confidential Information. Please upload your files to One Drive and share the link here.