Forum Discussion

Vikram_Thukral's avatar
Vikram_Thukral
New Member
8 years ago

Power BI showing impartial join

Hi,

 

For the purpose of being concise and brief, I will share an example of the problem I am facing.

 

I have a table called "KPI" with columns KPI_ID, KPI_Name.

I have another table for plans called "Total Plans" where I have a column for KPI ID and Plans.

 

In SSAS, I have created a relationship between the two IDs. The problem that arises is as follows. Let's say there are IDs present from 1-5 with their respective KPI names.

In power BI when pulling up plans for KPI names, I can only see plans for IDs 1-3 and not 4,5. Also when I view the table for Total Plans. KPIID I can see plans for all IDs ie. 1-5.

 

Also, when I create a calculated column KPIKey in Total Plans, I can see IDs 4,5.

                KPIKey = Related(KPI[KPI_ID])

 

What could be the reason for this impartial join that is reflecting in Power BI but not SSAS

1 Reply

  • v-jiascu-msft's avatar
    v-jiascu-msft
    Microsoft Employee

    Hi Vikram_Thukral,

     

    1. Do both tables have the data of 4 and 5?

    2. Can you share the file?

    3. How did you pull up plans for KPI names? In a table visual?

     

    Best Regards,

    Dale