Loading Power Bi Desktop data

[PBILover]

Hi,

I have a Cosmos db where i am getting data by Company . In this container i am getting 2 types of documents and they both are related by partition Key column. First document is having data like company name, partion Key, Client name, transaction information  etc  and second document  is  having data related to the events of transaction (Partition key, Event, (Event data)). In second document we dont have any company info and we can relate this with first document  through partition key only. actually its like one company transaction can have multiple events in a same container and  documents are related through partition key .

       To simplify , here i am trying to load data in 2 seperate tables. first is company transaction data filtered on company name.

and in second table loading all data  for the events by filtering on the column (event ) <> null  then makinge a relation ship and then  visualization on this. But in this approach i am facing the issue that in second table it is loading event data for all companies (As i am not able to filter out on company name for second document). 

Is there any approach to load data for a specific company in a second table? (like using DAX etc)

Thanks 

PBILover

[v-yingjl · Accepted solution]

Hi @PBILover ,

You can try:

1. Add filters for your reports in the filter pane.
2. Create a measure like this, put it in the visual filter and set its value as 1: measure = if(selectedvalue([company]) = "xxx",1,0)
3. Before loading data into power bi desktop, you can filter the specific company data in power query editor first, refer: Filter data (Power Query) 

Best Regards,
Community Support Team _ Yingjie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.