Forum Discussion
Sum Distinct Values (Two variables: PI and IO with multiple Partners)
Hello Community :smileyhappy: Same Objective in all below scenarios (2 scenarios, but one Pivot. Is it possible using DAX?): SUM UP Distinct Values (both for PI and IO, but special for IO I need...
Hi ankitpatira,
Thanks for your contribution.
I think I made a mistake and forgot to note that I have Billings and Costs amounts different fact tables.
On both tables I have some common fields like PI number, client, IO numbers, etc. I think my challenge is on how to connect both tables, create some measures and then set the power pivot (I also avoiding myself to use calculated columns).
Regards,
Thanks for your contribution.
I think I made a mistake and forgot to note that I have Billings and Costs amounts different fact tables.
On both tables I have some common fields like PI number, client, IO numbers, etc. I think my challenge is on how to connect both tables, create some measures and then set the power pivot (I also avoiding myself to use calculated columns).
Regards,
Hi bajimmy1983,
Using Matrix should work here.
For connecting tables, either we could combine those tables under Query Editor, or create relationships between them.
You may first take a look at the article below, about query tasks, or creating relationship:
Common query tasks in Power BI Desktop
Create and manage relationships in Power BI Desktop
If any further help needed, please post back.
Regards