'How to use if in a filtered row in powerbi?
My table looks like this
Table: Money holder
SerialNo Name
123 A
456 A
789 B
Table: Collected by
SerialNo Name
123 C
123 A
123 C
789 D
789 A
I need to see if there is any SerialNo with the same person in both the tables. What I tried to do was
CALCULATE( FIRSTNONBLANK('Collectedby'[Name], 1), FILTER(ALL('Collectedby'), Collectedby[SerialNo] = Moneyholder[serialno]))
And then I used if to see if the Name both are matching. But the issue here is that it looks for first value only and for Serial Number 123 it would be 'C'. But I used one more filter saying Moneyholder[name] = collectedby[name] then I would get blank for all other results.
How can I fixed this?
Desired Result: Table Money holder
SerialNo Name Collectedby
123 A A
456 A
789 B D
Sources
This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.
Source: Stack Overflow
| Solution | Source |
|---|
