Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi Experts
The following measure should always return back 2 irrespective of what as been selected in the sclier (CFD is not included in the sclier) - so if te user selects f2f from the sclier then the below measure returns 2 as there are 2 CFD values in the date range.... i keep on getting 1 if i select f2f and 1 for phone and 1 for virtual... as Days count....
Type | Data Value |
f2f | 1 |
phone | 1 |
CFD | 1 |
CFD | 1 |
Apple | 1 |
Virtual | 1 |
Solved! Go to Solution.
Hi @Invesco ,
Can you clarify on this?
I tried using the same measure that you have created, it is returning 2 even with slicers selected
HI @Invesco,
I’d like to suggest you take a look at the following link about all functions, they can be used to ignore specific filter effects.
Managing “all” functions in DAX: ALL, ALLSELECTED, ALLNOBLANKROW, ALLEXCEPT
Regards,
Xiaoxin Sheng
when i select ALL the measure works - however when i select the indivdual Type then it does not return the correct value for CFD... i have one fact table in the model and not date table as everything works of the FACT table fine
Hi @Invesco ,
Can you clarify on this?
I tried using the same measure that you have created, it is returning 2 even with slicers selected
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
107 | |
97 | |
75 | |
65 | |
53 |
User | Count |
---|---|
144 | |
103 | |
98 | |
85 | |
64 |