The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
hello every body,
im new in power bi and dax ,
Hi @Anonymous ,
‘VALUES ( 'Table'[Column1] )’ returns a one-column table that contains the distinct values from Column1.
‘CALCULATE ( MIN ( 'Table'[Column2] ), NOT ( ISBLANK ( 'Table'[Column3] ) ) )’ returns each group’s minimum value, for example, A, B and C.
In your measure, ‘KEEPFILTERS’ and ‘VALUES’ play the same role. ‘KEEPFILTERS’ is not needed in this measure.
avg = AVERAGEX ( KEEPFILTERS ( VALUES ( 'Table'[Column1] ) ), CALCULATE ( MIN ( 'Table'[Column2] ), NOT ( ISBLANK ( 'Table'[Column3] ) ) ) )
avg 2 = AVERAGEX ( VALUES ( 'Table'[Column1] ), CALCULATE ( MIN ( 'Table'[Column2] ), NOT ( ISBLANK ( 'Table'[Column3] ) ) ) )
Best Regards,
Icey
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
@Icey thank you its was clear for me, i did the same think i took off the Keepfilters and the result stay the same , if you mind if you have a tips or an equivalent of SQL groupby in dax .