Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Grow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.

Reply
Anonymous
Not applicable

Sum based on three distinct

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]))

 

Help.png

 

 

Could somebody help me?

1 ACCEPTED SOLUTION

It does not really help. 

 

I guess you will be needing the SUMMARIZECOLUMNS-function:

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

 

 

View solution in original post

4 REPLIES 4
sturlaws
Resident Rockstar
Resident Rockstar

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

Anonymous
Not applicable

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?

It does not really help. 

 

I guess you will be needing the SUMMARIZECOLUMNS-function:

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

 

 

Anonymous
Not applicable

Thank you for your help sir. 

Helpful resources

Announcements
RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

MayPowerBICarousel

Power BI Monthly Update - May 2024

Check out the May 2024 Power BI update to learn about new features.