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 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!!!

General Comment
Need Help
Tips and Tricks
  • amitchandak's avatar
    amitchandak
    4 years ago

    Anonymous , Try like

     

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

  • Jihwan_Kim's avatar
    Jihwan_Kim
    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]
    )
)

9 Replies