Forum Discussion
sum, filter and grouping issue
Hi Anonymous ,
Have you tried to change the filter direction in the relationship view directly?
If still not works, could you please consider sharing a simple sample file without any sesentive information for further discussion?
Best Regards,
Community Support Team _ Yingjie Li
Community SupportAccording to my test, the reason they cause this problem is that the cross-filter address between the date table and the message table is unique instead of both:
To resolve this, you can change the direction from one to both directly:
Or use the Crossfilter() function to modify its measurement:
soll =
CALCULATE (
SUM ( 'Projekt-Ressourcen-Zeit Posten'[Menge] ),
FILTER (
ALL ( 'Projekt-Ressourcen-Zeit Posten'[Emfassungsart] ),
'Projekt-Ressourcen-Zeit Posten'[Emfassungsart] = "soll"
),
CROSSFILTER ( 'Date'[Date], 'Post Ressource Kapazitat'[Date], BOTH )
)
Attached a sample file in the next one, hopes to help you.
Best regards
Community Support Team _ Yingjie Li
If this post helps,then consider Accepting it as the solution to help other members find it faster.
i used CROSSFILTER but it is not having correct answer. it gives me following result, which is still wrong, because i need to see how the total quantity of 1350 is spread between plannungressources.
- v-yingjl
Hi Anonymous ,
Have you tried to change the filter direction in the relationship view directly?
If still not works, could you please consider sharing a simple sample file without any sesentive information for further discussion?
Best Regards,
Community Support Team _ Yingjie Li