Forum Discussion

AndrewZ's avatar
AndrewZ
Icon for Helper I rankHelper I
1 year ago
Solved

Can't linked a summarised table

Hi   I've created a summarised table as I don't need all the detail to calculate a few averages but now I can't link that newly created table to my existing tables. PowerBI gives no error it just l...
Need Help
  • Deku's avatar
    Deku
    1 year ago

    Might be worth trying to create the relationship with TMDL view or Tabular Editor? 

Deku's avatar
Deku
Icon for Super User rankSuper User
1 year ago

Addcolumns(

Allnoblankrow(

'Total Investment'[cre0b_requestid],

'Total Investment'[cre0b_ppascenario],

'Total Investment'[Attribute] 

),

"Entity Currency", 

CALCULATE(SUM('Total Investment'[Running Total with Correct Signage])

)

)

 

This should work. SUMMARIZE,  VALUES and ALL considers blanks row. ALLNOBLANKROWS and DISTINCT does not.

This can cause circular dependancies which means you can't create the relationship.

AndrewZ's avatar
AndrewZ
Icon for Helper I rankHelper I
1 year ago

I tried this and got the same thing. Made the link, saved it and nothing happened. I didn't think it was blank values anyway as there were none. PowerBI doesn't even give an error message it just returns without doing anything which points to it being an unhandled exception. Then there is the fact that you just need to make a copy of the table to get a connection working which is bizarre.

 

To be more clear on that I have three satellite tables that allow users to select scenarios, project and year. The scenario project is really small and looks like this

 

The calculated table actually only has -1,0 and 1 (never blank). Now if I connect this column it fails but if I make a duplicate of this Scenario table and connect that table to the calculated one it works. Then all I have to do is link the first and second scenario tables and I get a working model. If there was a dependency error that wouldn’t work but the fact that it does makes me think bug but I’m hoping someone here can point out something I’ve missed so my model doesn’t have to have unnecessary tables.

 

I just unlinked the original table from everything else and it still won’t link to the new table. This is ridiculous.