Forum Discussion
Count if Filter help
Hi MasterSonic
Thanks for reaching out to us.
please try this
sample data
isduplicate = var _count=COUNTROWS('Table') return if(_count>1,MIN('Table'[Code]))Measure = var _t= FILTER('Table',[isduplicate]<>BLANK()) return COUNTX(DISTINCT(_t),[Code])result
Best Regards,
Community Support Team _Tang
If this post helps, please consider Accept it as the solution to help the other members find it more quickly.
Nah, that does not work for me.
And actually very first solution you sent gives me this : <ccon>A circular dependency was detected: Table[Column].</ccon>
I will rephrase my question maybe as I can't figure out how to solve it.
| Code | Task | Test | Value |
| 100 | Design | Wrong | OK |
| 200 | Check if blank | Innacurate | NO |
| 300 | Name | Correct | OK |
| 400 | Code | Dismiss | NO |
| 100 | Design | Wrong | OK |
| 200 | Check if blank | Innacurate | OK |
| 300 | Name | Correct | NO |
| 400 | Code | Dismiss | OK |
What I would like to get as visual :
| Test | Created Column/Measuremnt |
| Innacurate | here will be blank as none of Code,Task,Value are same in rows (Value column is different) |
| Wrong | here is 1 as for all Code rows have value 100 and same Task (Desing) and Value ( OK). |
| Correct | here will be blank as none of Code,Task,Value are same in rows |
| Dismiss | here will be blank as none of Code,Task,Value are same in rows |
IF ( COUNTROWS ( DISTINCT ( TableName ) ) <> COUNTROWS ( TableName ), 1 )
<ccon>A circular dependency was detected: Table[Column].</ccon>
Maybe its becouse I have many custom columns here created in PowerQueryWolf you please pastea screenshot of the fax code and the visual?