topic Re: Sigma ∑ symbol disappears after adding the relationship in DAX Commands and Tips

Sigma ∑ symbol disappears after adding the relationship

Winniethewinner — Wed, 15 Jun 2022 19:54:34 GMT

I've been struggling with this issue for much longer than I expected, so seeking some help here.

I created a dim table using DAX based on my fact table CLOSED, and using Index column to link them (relationship = both) - this way I can create a chart with dynamically switched axis. The stange thing is that after adding the relationship, all the Sigma ∑ symbol besides the numbers columns disappears. And the chart is not working properly, i.e. Dim Table VALUE is not switching based on attribute selected.

This is before I add relationship:

And this is after adding the relationship:

Plus, in this same report, I have a same thing for another fact table ADVANCED, but this one works no problem:

Also, I'm not using Tabular Editor in this report.

If anyone could please share some idears? Thank you.

Re: Sigma ∑ symbol disappears after adding the relationship

vapid128 — Thu, 16 Jun 2022 01:11:27 GMT

Could you upload your file?

Re: Sigma ∑ symbol disappears after adding the relationship

Winniethewinner — Thu, 16 Jun 2022 14:22:09 GMT

Thanks for the reply vapid128 , I added a Month Order table and relate it to CLOSED, and this works, although I'm not sure why...

Re: Sigma ∑ symbol disappears after adding the relationship

Winniethewinner — Fri, 17 Jun 2022 17:41:09 GMT

vapid128 I've just uploaded this Sample data . After the relationship is added between Index, Sigma ∑ symbol disappears.

Re: Sigma ∑ symbol disappears after adding the relationship

Anonymous — Tue, 21 Jun 2022 04:12:38 GMT

Hi Winniethewinner ,

This is the related document, you can view this content:

https://community.powerbi.com/t5/Desktop/Sigma-symbol-is-missing-I-can-t-summarize/td-p/1347759

https://github.com/TabularEditor/TabularEditor/issues/544

Best Regards,

Liu Yang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Re: Sigma ∑ symbol disappears after adding the relationship

Winniethewinner — Tue, 21 Jun 2022 13:14:26 GMT

Anonymous well, as mentioned in the original post I don't use calculation group and tabular editor in this file (I know this will by design elinimate the Sigma ∑).