Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
=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
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))
I 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.
@Anonymous , Can you tell what this calculation is doing
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
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
109 | |
98 | |
77 | |
66 | |
54 |
User | Count |
---|---|
144 | |
104 | |
101 | |
86 | |
64 |