Create a calculation median column

[Anonymous]

Dear Power Users,

I need to create a new column "calculating a median of UnitPrc value" group by the Same ProdCode, Vendor and ProdType

Please kindly help on a DAX syntax.

Thank you .

[SpartaBI · Accepted solution]

@Anonymous 

MedianUnitPrice =
VAR _current_prod_code = 'Table'[ProdCode]
VAR _current_vendor = 'Table'[Vendor]
VAR _current_prod_type = 'Table'[ProdType]
RETURN
CALCULATE(
		MEDIAN('Table'[UnitPrc]),
		REMOVEFILTERS('Table'),
		'Table'[ProdCode] = _current_prod_code,
		'Table'[Vendor] = _current_vendor,
		'Table'[ProdType] = _current_prod_type
)

Showcase Report – Contoso By SpartaBI

      

[Anonymous]

Thank you for your help : )

[SpartaBI]

@Anonymous my pleasure 🙂
Hey, check out my showcase report:
https://community.powerbi.com/t5/Data-Stories-Gallery/SpartaBI-Feat-Contoso-100K/td-p/2449543
Give it a thumbs up if you liked it 🙂