cancel
Showing results for
Did you mean:

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

Helper IV

## Need help to sum value

Hello everyone, I have 2 table below :

Table 1 :

Table 2 :

I want to sum value from Table 2 that Campus Code is unspecified into Table 1 (respectively Province Name ) . I don't want to show Unspecified in the table 1

Table 1 like :

Can everyone help me a dax ?

1 ACCEPTED SOLUTION
Community Support

You can try the following methods.

``````Lead Digital2 =
FILTER ( ALL ( Campus ), [Campus Name] = "Unspecified" ),
FILTER ( ALL ( 'Lead' ),
[Province Name] = SELECTEDVALUE ( Campus[Province Name] )
)
``````Lead Direct2 =
FILTER ( ALL ( Campus ), [Campus Name] = "Unspecified" ),
FILTER ( ALL ( 'Lead' ),
[Province Name] = SELECTEDVALUE ( Campus[Province Name] )
)
``Lead Referral2 = SUM('Lead'[# of Lead Referral])``
``Total Lead = [Lead Digital2]+[Lead Direct2]+[Lead Referral2]``

Is this the result you expect?

Best Regards,

Community Support Team _Charlotte

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

4 REPLIES 4
Community Support

You can try the following methods.
Measure:

``````Lead Digital2 =
FILTER ( ALL ( Campus ), [Campus Name] = "Unspecified" ),
FILTER ( ALL ( 'Data Lead' ),
[Province Name] = SELECTEDVALUE ( Campus[Province Name] )
)
)``````
``````Lead Direct2 =
FILTER ( ALL ( Campus ), [Campus Name] = "Unspecified" ),
FILTER ( ALL ( 'Data Lead' ),
[Province Name] = SELECTEDVALUE ( Campus[Province Name] )
)
)``````
``Total Lead = SUM('Data Lead'[# Of Lead Digital])+SUM('Data Lead'[# Of Lead Direct])+SUM('Data Lead'[# of Lead Referral])+[Lead Digital2]+[Lead Direct2]``

Is this the result you expect?

Best Regards,

Community Support Team _Charlotte

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Helper IV

Hi @v-zhangti ,

I want to Sum value from table 2 into table 1 and don't show the row Unspecified . Example :

I'm sorry maybe the link is wrong data, I had repaired the link above with a right data

Community Support

You can try the following methods.

``````Lead Digital2 =
FILTER ( ALL ( Campus ), [Campus Name] = "Unspecified" ),
FILTER ( ALL ( 'Lead' ),
[Province Name] = SELECTEDVALUE ( Campus[Province Name] )
)
``````Lead Direct2 =
FILTER ( ALL ( Campus ), [Campus Name] = "Unspecified" ),
FILTER ( ALL ( 'Lead' ),
[Province Name] = SELECTEDVALUE ( Campus[Province Name] )
)
``Lead Referral2 = SUM('Lead'[# of Lead Referral])``
``Total Lead = [Lead Digital2]+[Lead Direct2]+[Lead Referral2]``

Is this the result you expect?

Best Regards,

Community Support Team _Charlotte

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Helper IV

Hii @v-zhangti ,

Thank you so much !

Announcements

#### New forum boards available in Real-Time Intelligence.

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

#### Power BI Monthly Update - May 2024

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

#### Fabric certifications survey

Certification feedback opportunity for the community.

Top Solution Authors
Top Kudoed Authors