Do not summarize not working

[Anonymous]

Hello all,

I am connecting Power BI to SQL tables, table relatationships as below.

I am trying to create a table visual with  Group (from application master) and sla-measured (from summary) and sla-target (from target) when I choose don't summarize option it gives error as - Can't determine relationship between the fields.

[v-rzhou-msft · Accepted solution]

Hello @gary5

In addition to amitchandak's response, this error can be caused by one to many relationships.

You can create relationships between the Summary table and the Set Table directly (many to many)

Inactive this relationship:

You can create a measure and add some other columns (number type) to the Tagert table in this table visual table and demmarize this column.

Or you can activate this relationship and delete relatioshipe with App Table.

And add a calculated App_Group in Summary or Target Table.

App_Group = CALCULATE(MAX(App_Master[APP_Group]),FILTER(App_Master,App_Master[APP_ID]=SLA_SUMMARY_DETAIL[APP ID]))

Result:

Best regards

Rico Zhou

If this post helps,then consider Accepting it as the solution to help other members find it faster.

[amitchandak]

@Anonymous , If Table C is Common Table For A and B . means C- A (1-M) and C-B(1-M)

then you can take unsummarized columns from C and either from A or B, not both.

[Shekar_89]

@amitchandak  Then what should we do if we want to display unsummarized columns (using Don't summarize) for both tables in a "Table Visual".