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
parry2k's avatar
parry2k
Icon for Super User rankSuper User
7 years ago

Prabhu_MDU can you send pbix file if it doesn't contain sensitive information and will do it for you, I guess cte table has one to many relationship with fact table?

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.