group and sum

[Anonymous]

Hello,

i would be thankful, if youcould help me to find out how to solve this problem.

Here is my sample inputs:

expected sample output:( to sum th soll quantity according to month, plannungressournr. and ressourcenr.)

my result after implementation is as following which the concept is not the same as i what i expected. because soll is total quantity but i want to have it seperatly for each group.

i used this measurement for calculating"soll", but in my tables what i see is different than my expected output.

Thank you for your time.

[amitchandak]

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

[AilleryO]

Hi,

Did you try using SUMMARIZECOLUMNS ? or SELECTEDVALUE?

Let us know

[Anonymous]

i used SUMMARIZECOLUMNS  but if i am right,its giving me result in new tablebut i want to have a measure in my dashboard and use it with matrix visualisation.

[AilleryO]

Hi,

You're right the SUMMARIZECOLUMNS returns multiple results, but as far as I understand your problem, you want to "filter" with the line context.

Try adding a SELECTEDVALUE in your calculation :

More details on that :

https://www.sqlbi.com/articles/using-the-selectedvalue-function-in-dax/

or

https://docs.microsoft.com/fr-fr/dax/selectedvalue-function

But for me the SQLBI explanation is more clear.

Let us know if it works...