QlikView calculation to Power BI DAX

[Anonymous]

=num(
(Sum({<PARTS_TYPE={'Wholegoods'},SHIP_FROM_ORGANIZATION_NAME={'IM','ID'},CM={'1'},FiscalMonth=,FiscalQuarter=,FiscalYear=>}GOODS_VALUE_GBP)/1000)
,'#,##0')

Above is a QlikView calculation.

How would I go out of producing the exact same calculation, but in Power BI DAX or Measure?

Thanks,

Chin_IT

[Anonymous]

Hi  @Anonymous ,

Seems like that you can transfer the function into sumx (table,expression),such as :

measure=sumx(filter(all(table),PARTS_TYPE='Wholegoods'&&SHIP_FROM_ORGANIZATION_NAME in {'IM','ID'}&&CM='1'&&Fiscaldate=max(GOODS_VALUE_GBP)/1000)) 

 
Best Regards,
Kelly

Did I answer your question? Mark my post as a solution!

[Anonymous]

I have done what you have said but still an issue 

[v-kelly-msft]

Hi  @Anonymous ,

Can you upload your .pbix file to onedrive business and share the link with me?

Much appreciated.

 
Best Regards,
Kelly

Did I answer your question? Mark my post as a solution!

[amitchandak]

@Anonymous , Can you tell what this calculation is doing

[Anonymous]

Hello,

I am unsure as I did not create the qlikview dashboard and calculations. I am simply just migrating an existing QlikView dashboard into Power BI and in doing so, I need to produce the calculations. From what it looks like the calculation is doing a sum using set analysis.

I am trying to replicate this into Power BI. 

Thanks,

Chin_IT