I have 2 files one is in qliksense and other is in power bi .. both have same tables and relationships..
qliksense expression is
if([Billing Doc. currency_WAERK] = 'USD',
sum({<[Billing Type_FKART] -={'ZG2','ZL2'}>}[Billing Sales Amount_NETWR])*139.2,
sum({<[Billing Type_FKART] -={'ZG2','ZL2'}>}[Billing Sales Amount_NETWR]))
and
power bi expression is
UPDATED
Total Sales Variable =
CALCULATE (
SUMX (
VALUES ( test_billing_doc_header[Billing Doc. currency_WAERK] ),
IF (
test_billing_doc_header[Billing Doc. currency_WAERK] = "USD",
139.2,
1
) * SUM ( test_biilingg_doc_item[Billing Sales Amount_NETWR] )
),
test_billing_doc_header[Billing Type_FKART] <> "ZG2" && test_billing_doc_header[Billing Type_FKART] <> "ZL2"
)
now the problem is qliksense expression show value 26,599,175,877.32 and power bi shows 6,800,260,015,222,45
and i want qliksense value in power bi ..
this is the link for power bi file .. https://www.dropbox.com/s/i8aazcb19zt50l5/test4.pbix?dl=0
and this is for qliksense https://www.dropbox.com/s/jltgdls5rbintn4/test.qvf?dl=0
any help ?