Forum Discussion
DAX query
Hi, I am new in learning DAX query. I am trying to count the project numbers based on approving person, but I would like the results to be in same row as each Team Member since some of them ar...
Hi Anonymous ,
Here are the steps you can follow：
1. Create calculated column.
Count Funded Project Approval by Approving Person = var _table= SUMMARIZE( 'Table','Table'[Team Member]) var _table2= ADDCOLUMNS( _table,"1", COUNTX( FILTER('Table', 'Table'[Approving Person]=EARLIER([Team Member])&&[Current Status]="Funded"),[Current Status])) var _value= MAXX( FILTER(_table2,[Team Member]=EARLIER('Table'[Team Member])),[1]) return IF( _value=BLANK(),0,_value)Project Count by Team Member= CALCULATE( DISTINCTCOUNT('Table'[Team Member]))2. Result:
Best Regards,
Liu Yang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly
Hi Anonymous ,
Here are the steps you can follow：
1. Create calculated column.
Count Funded Project Approval by Approving Person =
var _table=
SUMMARIZE(
'Table','Table'[Team Member])
var _table2=
ADDCOLUMNS(
_table,"1",
COUNTX(
FILTER('Table',
'Table'[Approving Person]=EARLIER([Team Member])&&[Current Status]="Funded"),[Current Status]))
var _value=
MAXX(
FILTER(_table2,[Team Member]=EARLIER('Table'[Team Member])),[1])
return
IF(
_value=BLANK(),0,_value)Project Count by Team Member=
CALCULATE(
DISTINCTCOUNT('Table'[Team Member]))2. Result:
Best Regards,
Liu Yang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly
It works now, thank you so much!