cancel
Showing results for
Did you mean:

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Continued Contributor

## Help with SUMIF-like DAX

Hi,

I'm trying to create a formula which will calculate the sum of income (from the income table) where a URN in the income table matches a URN in the registrations table

In Excel-lingo this would be something like:

"=sumif(registrationsURN, incomeURN, incomeAmount)"

Can anyone help?

Thanks

5 REPLIES 5
Continued Contributor

Establishing a relationship between the two tables should do the trick in terms of getting the "If table1[urn] = table2[urn] then sum(income)"

Community Champion

the general formula will be something like this...

Measure = CALCULATE(SUM(Table[Column]), Filter(s).....)

but how you list the filters depends on what you are trying to accomplish

you need to provide more details

Continued Contributor

Thanks Sean

I have two tables:

1. Registrations (columns include "URN", "Registration Date" as well as other fields relating to the registration. URN is not unique/primary key)

2. Income (columns include "URN", "Income Amount", "Income date" as well as other field relating to the income. Again, URN is not unique/primary key).

I'm trying to create a measure which will give me the income from the Income table where the URN is also present in the Registrations table.

Continued Contributor

I seem to have got this working

I created a lookup column ("RegisteredURN"), using LOOKUPVALUE in the Income table to lookup the URN from a unique version of the URNs from the Registrations table.

Then I created a measure in the Income table:

CALCULATE(sum(Income[Income Amount]),Income[RegisteredURN]<>"")

Community Champion

@alexei7 Great looks like you got it. SUM [Income Amount] for all non blank [URN]

Announcements

#### Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

#### Power BI Monthly Update - August 2024

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

#### Fabric Community Update - August 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors
Top Kudoed Authors