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
  • 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]
    )
)
amitchandak's avatar
amitchandak
Super User
4 years ago

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

thanks a lot amitchandak , you really  helped me !