Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

Count DAX

Hi Community, I have the following table: Project ID Project Sub ID Value 100 100A 10 100 100B 20 100 100B 30 101 101A 40 102 102A 60 102 102B 80 102 102C 90...
Need Help
Show and Tell
Tutorial Requests
  • ryan_mayu's avatar
    ryan_mayu
    5 years ago

    Anonymous 

    please try to create a measure

    Measure = CALCULATE(DISTINCTCOUNT('Table'[Project Sub ID]),FILTER(all('Table'),'Table'[Project ID]=max('Table'[Project ID])))

    pls see the attachment below

amitchandak's avatar
amitchandak
Super User
5 years ago

Anonymous , Based on what I got,

 

You can create a measure

= count(Table[Value])

and disply  it with project and sub project id in visual

 

or create a table

Summarize(Table, Table[Project], Table[Sub Project], "Count", count(Table[Value]))

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    amitchandak,

    Thank you for your response. Sorry I put in the wrong output and requirement, I updated so it will do distinct count the number of project id repeated for each project sub id. What should I do in this cases instead?