Forum Discussion

Analitika's avatar
Analitika
Post Prodigy
5 years ago

distinct SUMMARIZE

I have formula   CALCULATETABLE( SUMMARIZE(_op,[apyv_id],_OP[Column]), FILTER ( _OP, [P] <> 1 ), FILTER ( _OP, NOT ISBLANK ( _OP[apyv_id] ) ), FILTER ( 'ACC', [Sas] = "1111" ) )   ...
Need Help
Tips and Tricks
lbendlin's avatar
lbendlin
Super User
5 years ago

Remove duplicate rows in Power Query or use DISTINCT/VALUES/ALL in DAX.