Need to convert qlik expression to DAX

Anonymous — Mon, 03 Oct 2022 18:09:09 GMT

Hello Team,

I need to convert the qlik Expression to dax.

2 table in power BI

Table Fact

Table combination

ColorNumber field from Fact table

RegrindColorNumber field from combination table

_RegrindStartingInventory field from combination table

below is the Qlik Expression

Sum(distinct if(left(ColorNumber,1)=left(RegrindColorNumber,1),_RegrindStartingInventory,0))

I have tried converting into DAX but result is not matching.

Re: Need to convert qlik expression to DAX

v-chenwuz-msft — Tue, 04 Oct 2022 02:35:46 GMT

Hi Anonymous ,

Please try this:

SUMX( FILTER( 'combination table', LEFT( [RegrindColorNumber], 1 ) = LEFT( 'Fact table'[ColorNumber], 1 ) ), _RegrindStartingInventory )

Best Regards

Community Support Team _ chenwu zhu

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.