calculated sum column based on another column

[Anonymous]

Hi, I'm a beginner in Power BI, and I have a table like this:

I need a calculated column, with the total distinct values of 'Talle' column, if value in existencia is equal to 1. In the image above, the result should be 8, because there are 9 unique different values, but only 8 have 1 in 'Existencia' ( Talle= 3 , has Existencia=0). It' important to consider that , the same must be done for each Parent Item. Maybe in another Parent Id values, I could have the same values in 'Talle' Column. How could it be done? . Thanks in advance!!!

[amitchandak · Accepted solution]

@Anonymous , Try like

calculate(distinctCOUNT(Table[Talle]), filter(Table, Table[existencia] =1))

[ribisht17]

Please check this Solved: Expression.Error: No se reconoce el nombre 'IF'. A... - Microsoft Power BI Community

[ribisht17]

You are using DAX, not Power Query Formula Language. See Create calculated columns for more information.

[Jihwan_Kim · Accepted solution]

Hi,

Please check the below picture and the attached pbix file.

It is for creating a new column.

Distinct count of Talle CC =
COUNTROWS (
    SUMMARIZE (
        FILTER (
            Data,
            Data[Existencia] = 1
                && Data[Parent_Item] = EARLIER ( Data[Parent_Item] )
        ),
        Data[Talle]
    )
)

[Anonymous]

Thanks a lot @Jihwan_Kim , you really  helped me ! 

[amitchandak · Accepted solution]

@Anonymous , Try like

calculate(distinctCOUNT(Table[Talle]), filter(Table, Table[existencia] =1))

[Anonymous]

@amitchandak , It's not considering different Parent_Item  :

[amitchandak]

@Anonymous , try to create as a measure

new column as

calculate(distinctCOUNT(Table[Talle]), filter(Table, Table[existencia] =1 && [Parent_Item] = earlier([Parent_Item] ) ))

[Anonymous]

thanks a lot @amitchandak , you really  helped me ! 

[Anonymous]

Hi, @amitchandak . Thanks for the answer! I 'm getting this error: