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 th...
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
Greg_Deckler
Community Champion
Community Championlukiwu 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