cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Anonymous
Not applicable

QlikView calculation to Power BI DAX

=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

5 REPLIES 5
v-kellya-msft
Solution Sage
Solution Sage

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
Not applicable

dax expression.PNGI have done what you have said but still an issue 

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
Super User
Super User

@Anonymous , Can you tell what this calculation is doing

Did I answer your question? Mark my post as a solution! Appreciate your Kudos!! !!
Dashboard of My Blogs !! Connect on Linkedin
Want To Learn Power BI
Learn Power BI Beginners !! Advance Power BI Concepts !! Power BI For Tableau User !! Learn Power BI in Hindi !!
Proud to be a Super User!
Anonymous
Not applicable

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

Helpful resources

Announcements
Power BI December 2021 Update_carousel 768x460.jpg

Check it Out!

Click here to read more about the December 2021 Updates!

User Group Leader Meeting January 768x460.png

Calling all User Group Leaders!

Don't miss the User Group Leader meetings on January, 24th & 25th, 2022.

Jan 2022 Dev Camp 768x460 copy.png

Power BI Dev Camp- January 27th, 2022

Mark your calendars and join us for our next Power BI Dev Camp!

Top Solution Authors
Top Kudoed Authors