Forum Discussion

Prabhu_MDU's avatar
Prabhu_MDU
Icon for Advocate I rankAdvocate I
7 years ago

Alternate for my SQL query in DAX

,cte_Allocation as ( select distinct cr.RemittanceCode, sum(fa.AllocAmount_OC_A) as 'AllocationAmount_Orig', sum(fa.AllocAmount_FC_A) as 'AllocationAmount_Func' from cte_Remittance cr /* <= A ...
Need Help
Prabhu_MDU's avatar
Prabhu_MDU
Icon for Advocate I rankAdvocate I
7 years ago

sorry, I could not share the pbix file, since it has very sensitive data.. 

parry2k's avatar
parry2k
Icon for Super User rankSuper User
7 years ago

basically you have to setupi relationship between cte and fact table in powerbi on common column and then everything should work.

 

 I'm assuming cte to fact is one to many relationship.