Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and a 50 percent discount on exams.
Get startedEarn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hi Experts
I am trying to sum the occurance of CFD , but i want the summed value to ignore what is selected in the Filter | Slicer
VAR Amt give me the corrcet value but when i select f2f from the select the value return 0 and so on...CFD are not in the slicer..
Type | Data Value |
f2f | 1 |
phone | 1 |
CFD | 1 |
CFD | 1 |
Phone | 1 |
Virtual | 1 |
Solved! Go to Solution.
Hi @Invesco ,
Please try this:-
Days # =
CALCULATE (
SUM ( Table1[data_value] ),
FILTER (
ALL ( Table1[activity_type_1] ),
Table1[activity_type_1] = "customer_facing_day"
)
) + 0
Thanks,
Samarth
Best Regards,
Samarth
If this post helps, please consider accepting it as the solution to help the other members find it more quickly.
Appreciate your Kudos!!
Connect on Linkedin
Hi @Invesco ,
Please try this:-
Days # =
CALCULATE (
SUM ( Table1[data_value] ),
FILTER (
ALL ( Table1[activity_type_1] ),
Table1[activity_type_1] = "customer_facing_day"
)
) + 0
Thanks,
Samarth
Best Regards,
Samarth
If this post helps, please consider accepting it as the solution to help the other members find it more quickly.
Appreciate your Kudos!!
Connect on Linkedin
Thanks you sir you gave me a clue and i have fixed the solution
HI Samarth - it ignores the filter but the sum of the CFD is incorrect know - should be 2....based on the date column....
@Invesco Based on data provided below code would be ideal code:-
Days # =
CALCULATE (
SUM ( 'Table (5)'[Data Value] ),
FILTER (
ALL ( 'Table (5)'[Type] ),
'Table (5)'[Type] = "CFD"
)
) + 0
Best Regards,
Samarth
If this post helps, please consider accepting it as the solution to help the other members find it more quickly.
Appreciate your Kudos!!
Connect on Linkedin
apologies the CFD days does not remain at 2 when filtering the data in the table based on the sclier.....NOT WORKING MY ERROR...can you provide a pbix with the calculation