Forum Discussion
COUNTROWS Function to exclude repeated value
hello Experts. I want to count the number of "Completed" Projects where the function will check if there is any repeat in Column "ID" and if there is any repeat then it will check if both "Status" f...
Hi,
Measure for 'Completed':
Completed := VAR MyTable = SUMMARIZE( 'Table', [ID], "ID Count", COUNTROWS( 'Table' ), "Completed Count", CALCULATE( COUNTROWS( 'Table' ), 'Table'[Overall ACL Status] = "Completed" ) ) VAR CompletedCheck = SUMX( MyTable, 0 + ( [ID Count] = [Completed Count] ) ) RETURN CompletedCheckRegards
Try:
Pending := VAR MyTable = CALCULATETABLE( VALUES( 'Table'[ID] ), 'Table'[Status] = "Pending" ) RETURN COUNTROWS( MyTable )Regards
PijushRoy
Community Champion
Community ChampionHi Anonymous
Please try this for Status Completed
= VAR _unique = CONCATENATE(ID, STATUS)
VAR _completed = CALCULATE(DISTINCTCOUNT(_unique),'Table'[Status]="Completed')
RETURN
SWITCH(
TRUE(),
_completed > 0, _completed,
CALCULATE(DISTINCTCOUNT(_unique),'Table'[Status]="Pending')
If not solved, please share sample data and keep posted
If solve your requirement, please mark this answer as SOLUTION
If this comment helps you, please LIKE this comment/Kudos