Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

sum, filter and grouping issue

Hello, i am a beginner, i would be thankfull, if you could help me to undrestand what is my mistakes in this report, i looked up but i couldnt undrestand how to solve it:   in the fist table, „sol...
Need Help
  • v-yingjl's avatar
    v-yingjl
    5 years ago

    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

amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
5 years ago

Anonymous , Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.

M sollmenge = CALCULATE(
SUM('Projekt-Ressourcen-Zeit Posten'[Menge])
,FILTER(
('Projekt-Ressourcen-Zeit Posten'[Erfassungsart])
,'Projekt-Ressourcen-Zeit Posten'[Erfassungsart] = "soll"
)
)

Try like