Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Measure Question

Hi, i am trying to create a measure to pupulate a teable but am struggling. I have a quite comlicated datase, but have shown a simplified version below.   Projects Table This contains a list of p...
Need Help
v-jingzhang's avatar
v-jingzhang
Community Support
5 years ago

Hi Anonymous 

You can create measures like below. Download the PBIX file for details.

Benefits = COUNT('Benefits Register'[Project ID])

Benefits Active = COUNTX(FILTER('Benefits Register','Benefits Register'[Benefit Status]="Active"),'Benefits Register'[Project ID])

Changes = COUNT('Change'[Project ID])

Changes Active = COUNTX(FILTER('Change','Change'[Change Status]="Active"),'Change'[Project ID])

 

Kindly let me know if this helps.
Community Support Team _ Jing
If this post helps, please Accept it as the solution to help other members find it.