Forum Discussion
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 ...
sorry, I could not share the pbix file, since it has very sensitive data..
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.