topic Sum based on three distinct in DAX Commands and Tips

Sum based on three distinct

Anonymous — Thu, 31 Oct 2019 09:34:27 GMT

Hi!

I have a set of data that cannot be changed and it looks like vizualized below. I want to based on distinct value of the column "Project", the distinct value of the column "Department" and as well as a distinct value of the column "Calculation" to sum the values in column "Values".

I created this table by entering

Avdelning =

DISTINCT(SELECTCOLUMNS(Economy;"Project";Economy[Project];"Department";Economy[Department];"Calculation";Economy[Calculation]))

Could somebody help me?

Re: Sum based on three distinct

sturlaws — Thu, 31 Oct 2019 10:53:41 GMT

Hi, Anonymous

I don't understand your desired outcome or your data. Could you please read this: How to Get Your Question Answered Quickly ,

and reformulate your question?

Cheers,
Sturla

Re: Sum based on three distinct

Anonymous — Thu, 31 Oct 2019 11:04:05 GMT

Hi!

Sorry, I realized it wasn't the best description.

I want something like SUMIFS in excel. I want to sum the costs based on project, department and calculation.

Is this more clear?

Re: Sum based on three distinct

sturlaws — Thu, 31 Oct 2019 11:54:46 GMT

It does not really help.

I guess you will be needing the SUMMARIZECOLUMNS-function:

Avdelning = SUMMARIZECOLUMNS ( Economy[Project]; Economy[Department]; "Something"; SUM ( Economy[Whatever] ) )

Re: Sum based on three distinct

Anonymous — Thu, 31 Oct 2019 12:19:50 GMT

Thank you for your help sir.