Forum Discussion
total value in table
Luckily I like skiing in Austria and know a bit of German 😉
Can you share your original dataset that is below this visual? There seems to be something wrong going on there. For example, is "Soll Stunden pro Woche" in the same or related table as your "Beginn der Woche" and "Ende der Woche" columns? If not, that would explain why this is happening as it is just returning the total sum of Soll Stunden of that table, unfiltered by the context of the table visual.
Kind regards
Djerro123
-------------------------------
If this answered your question, please mark it as the Solution. This also helps others to find what they are looking for.
Keep those thumbs up coming! 🙂
I asume this column is not a column but a Measure, is that correct?
Measures are evaluated for the total row as well. In the table it is evaluated for every filtered context (by End of Week) but when it is evaluated for the Total row it is evaluated for a context not filtered by End of Week (so the whole dataset). This might give suprising results.
If this is a column, then please share your PBIX as I cannot reproduce this behaviour on my machine. If you want, you can PM me the link if you do not want to share publicly here and I can have a look for you.
EDIT: upon looking closer at your second screenshot I do have to conclude this is indeed a column. However, you are showing an extract from Excel, not from PowerBI? Why is that?
Kind regards
Djerro123
-------------------------------
If this answered your question, please mark it as the Solution. This also helps others to find what they are looking for.
Keep those thumbs up coming! 🙂
JarroVGIT The content is in a different language. It is a column(whole number), not a measure. Could I just create a measure to give me the total?
I tried this but it just gave me the same values:
Measure = SUMX('table';table[Soll Stunden pro Woche])Thanks.Luckily I like skiing in Austria and know a bit of German 😉
Can you share your original dataset that is below this visual? There seems to be something wrong going on there. For example, is "Soll Stunden pro Woche" in the same or related table as your "Beginn der Woche" and "Ende der Woche" columns? If not, that would explain why this is happening as it is just returning the total sum of Soll Stunden of that table, unfiltered by the context of the table visual.
Kind regards
Djerro123
-------------------------------
If this answered your question, please mark it as the Solution. This also helps others to find what they are looking for.
Keep those thumbs up coming! 🙂
Yeah, that was the issue. The soll stunden were in a different entity. I've now related the 2 entities and it solved my total issue.
Thanks