Forum Discussion
Count the Items which has single status
Hi, I have been breaking my head to find the solution. I have a list of assets. Need to count the assets if it only has the FIXED status and not having any other rows with different status, also with...
Hi Anonymous
You can create below measure. 'Table' is my table's name, replace it with yours.
Measure = VAR vTable = FILTER('Table','Table'[Patch Type]="OS") VAR vTable2 = SUMMARIZE(vTable,'Table'[Domain],'Table'[Machine],"All_Status",CONCATENATEX(VALUES('Table'[Status]),'Table'[Status],",")) RETURN COUNTROWS(FILTER(vTable2,[All_Status]="Fixed"))Then you can add a table visual in the report, put Domain column and this measure into it to show the count for each domain. See the attachment.
Best Regards,
Community Support Team _ Jing
If this post helps, please Accept it as Solution to help other members find it.
amitchandak
Super User
Super UserAnonymous , Try a measure like
countx(filter(summarize(Table, Table[Domain], Table[Machine],"_1",, distinctCOUNT(Table[Status])), [_1]=1),[Machine] )