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
I cannot see the error here in my DAX' the filter filter is correct when I want to count the values and exclude blanks from second column I get an error..
Non MS Apps. = CALCULATE(COUNT(JohnH_SPO_EUCPriorityListAllDiv[Count]),FILTER(JohnH_SPO_EUCPriorityListAllDiv,JohnH_SPO_EUCPriorityListAllDiv[Microsoft or Not] = "Retain" || FILTER(JohnH_SPO_EUCPriorityListAllDiv,JohnH_SPO_EUCPriorityListAllDiv[Risk Based Criteria] <> BLANK())))
Solved! Go to Solution.
should you not use && rather than ||? what error are you getting
Non MS Apps. =
CALCULATE (
COUNT ( JohnH_SPO_EUCPriorityListAllDiv[Count] ),
FILTER (
JohnH_SPO_EUCPriorityListAllDiv,
JohnH_SPO_EUCPriorityListAllDiv[Microsoft or Not] = "Retain"
&& JohnH_SPO_EUCPriorityListAllDiv[Risk Based Criteria] <> BLANK ()
)
)
Proud to be a Super User!
should you not use && rather than ||? what error are you getting
Non MS Apps. =
CALCULATE (
COUNT ( JohnH_SPO_EUCPriorityListAllDiv[Count] ),
FILTER (
JohnH_SPO_EUCPriorityListAllDiv,
JohnH_SPO_EUCPriorityListAllDiv[Microsoft or Not] = "Retain"
&& JohnH_SPO_EUCPriorityListAllDiv[Risk Based Criteria] <> BLANK ()
)
)
Proud to be a Super User!
Thank you sir
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 |
---|---|
109 | |
98 | |
77 | |
66 | |
54 |
User | Count |
---|---|
144 | |
104 | |
101 | |
86 | |
64 |