Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
Hello everyone, I have 2 table below :
Table 1 :
Table 2 :
I post a pibx in that link : https://drive.google.com/file/d/1v5l0TgW5xPf0o5IqxBqPHSJ59jM-fP-8/view?usp=share_link
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 ?
Solved! Go to Solution.
Hi, @sakuragihana
You can try the following methods.
Lead Digital2 =
CALCULATE ( SUM ( 'Lead'[# Of Lead Digital] ),
FILTER ( ALL ( Campus ), [Campus Name] = "Unspecified" ),
FILTER ( ALL ( 'Lead' ),
[Province Name] = SELECTEDVALUE ( Campus[Province Name] )
)
)+SUM('Lead'[# Of Lead Digital])
Lead Direct2 =
CALCULATE ( SUM ( 'Lead'[# Of Lead Direct] ),
FILTER ( ALL ( Campus ), [Campus Name] = "Unspecified" ),
FILTER ( ALL ( 'Lead' ),
[Province Name] = SELECTEDVALUE ( Campus[Province Name] )
)
)+SUM('Lead'[# Of Lead Direct])
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.
Hi, @sakuragihana
You can try the following methods.
Measure:
Lead Digital2 =
CALCULATE ( SUM ( 'Data Lead'[# Of Lead Digital] ),
FILTER ( ALL ( Campus ), [Campus Name] = "Unspecified" ),
FILTER ( ALL ( 'Data Lead' ),
[Province Name] = SELECTEDVALUE ( Campus[Province Name] )
)
)
Lead Direct2 =
CALCULATE ( SUM ( 'Data Lead'[# Of Lead Direct] ),
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.
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
Hi, @sakuragihana
You can try the following methods.
Lead Digital2 =
CALCULATE ( SUM ( 'Lead'[# Of Lead Digital] ),
FILTER ( ALL ( Campus ), [Campus Name] = "Unspecified" ),
FILTER ( ALL ( 'Lead' ),
[Province Name] = SELECTEDVALUE ( Campus[Province Name] )
)
)+SUM('Lead'[# Of Lead Digital])
Lead Direct2 =
CALCULATE ( SUM ( 'Lead'[# Of Lead Direct] ),
FILTER ( ALL ( Campus ), [Campus Name] = "Unspecified" ),
FILTER ( ALL ( 'Lead' ),
[Province Name] = SELECTEDVALUE ( Campus[Province Name] )
)
)+SUM('Lead'[# Of Lead Direct])
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.
User | Count |
---|---|
25 | |
11 | |
8 | |
6 | |
6 |
User | Count |
---|---|
30 | |
13 | |
11 | |
9 | |
6 |