Forum Discussion
Delete rows only if
Keks Try:
Measure = VAR __Seq = MAX('Table'[Sequence]) VAR __Result = SWITCH(TRUE(), MAX('Table'[Description]) = "Changed Qty", 1, COUNTROWS(FILTER(ALL('Table'), [Sequence] = __Seq)) = 1, 1, 0 ) RETURN __Result
Keks Try:
Measure =
VAR __Seq = MAX('Table'[Sequence])
VAR __Result =
SWITCH(TRUE(),
MAX('Table'[Description]) = "Changed Qty", 1,
COUNTROWS(FILTER(ALL('Table'), [Sequence] = __Seq)) = 1, 1,
0
)
RETURN
__Result
I haven't tested it yet but could you please explain me? 🙂
Keks OK, well, the measure returns 1 for the rows you want and 0 for the rows you don't want. Then you just use the Filters pane to filter for a value of 1. This removes the 0's from your visual. It's a version of a Complex Selector. The Complex Selector - Microsoft Fabric Community
If you want to actually delete, delete the rows you would need to do that in Power Query but PQ doesn't have a switch statement so you would have to use nested if then else statements. PBIX is attached below signature.
It is working perfecly well... So thank you.
I just need to understand all the functions used :-).One more time, thank you!
Greg_Deckler not possible to use this measure in a slicer or a filter. How can I do ? 😞