Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Count values for a column while filtering another column

Hi Power BI Comunity, please help I need to count values for column "Items_Category" in Power BI, if my source only gives me 2 columns- Category & Items? Items_Category is the output in 3rd column/...
Need Help
  • Pragati11's avatar
    Pragati11
    6 years ago

    Hello @Gguliani ,

    Try creating a column like the following:

    CountCalc ? CALCULATE(SUM(tablename[Items]), FILTER(tablename, tablename[Category] ? EARLIER(tablename[Category] )))

    Thank you

    Pragati

Pragati11's avatar
Pragati11
Super User
6 years ago

Hello @Gguliani ,

Try creating a column like the following:

CountCalc ? CALCULATE(SUM(tablename[Items]), FILTER(tablename, tablename[Category] ? EARLIER(tablename[Category] )))

Thank you

Pragati

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Getting an error Pragati11 , field names and table names are different than dummy values asked in the query

 

 

  • Pragati11's avatar
    Pragati11
    Super User
    6 years ago

    Hi Anonymous ,

     

    You forgot to close a bracket after SUM function in your DAX. Check my dax expression again.

     

    Thanks,

    Pragati

    • Anonymous's avatar
      Anonymous
      Not applicable
      6 years ago

      That's reckless from me. Thanks Pragati11