Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

calculated sum column based on another column

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 imag...
General Comment
Need Help
Tips and Tricks
Jihwan_Kim's avatar
Jihwan_Kim
Icon for Super User rankSuper User
4 years ago

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's avatar
Anonymous
Not applicable
4 years ago

Thanks a lot Jihwan_Kim , you really  helped me !