Forum Discussion
Solved
By duplicates only show false value
Hello,
I have a question regarding the table in report view in Power BI Desktop. I need to get rid off the rows for the same customer where for example in Col1 there were True and False value at the same time and it should show me only the False value at the end. And when there's only one row with True value then it should show me this True value.
It would be filtered dynamically by date as well. Do you have any idea, how to deal with this case?
lukiwu Probably some type of Complex Selector: The Complex Selector - Microsoft Fabric Community. PBIX is attached below signature:
Measure = VAR __Customer = MAX('Table'[Customer]) VAR __Table = FILTER(ALL('Table'), [Customer] = __Customer) VAR __Result = IF( COUNTROWS(__Table) = 1, 1, IF( MAXA([Col1]) = 0 || MAXA([Col2]) = 0 || MAXA([Col3]) = 0, 1, 0 ) ) RETURN __Result
1 Reply
lukiwu Probably some type of Complex Selector: The Complex Selector - Microsoft Fabric Community. PBIX is attached below signature:
Measure = VAR __Customer = MAX('Table'[Customer]) VAR __Table = FILTER(ALL('Table'), [Customer] = __Customer) VAR __Result = IF( COUNTROWS(__Table) = 1, 1, IF( MAXA([Col1]) = 0 || MAXA([Col2]) = 0 || MAXA([Col3]) = 0, 1, 0 ) ) RETURN __Result