Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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.
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.
@v-yangliu-msft 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 ∑).
Could you upload your file?
@vapid128 I've just uploaded this Sample data . After the relationship is added between Index, Sigma ∑ symbol disappears.
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...
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
42 | |
21 | |
21 | |
14 | |
13 |
User | Count |
---|---|
43 | |
39 | |
33 | |
18 | |
17 |