The ultimate Microsoft Fabric, Power BI, Azure AI, and SQL learning event! Join us in Stockholm, Sweden from September 24-27, 2024.
2-for-1 sale on June 20 only!
Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started
I am using this Dax as a measure -
https://drive.google.com/file/d/1dGREcWSPPDGj8MBnQNAcqeKV_s1swcG5/view?usp=drivesdk - This one shows incorrect count when using the dax in calculated Column
Solved! Go to Solution.
The "Colleague Name" is from another column. However, I was able to resolve the issue by separating the filter.
IsDesiredCause =
'Colleague Events'[CAUSE2] IN {"didyoumeanAutomatic", "didyoumeanClick", "searchboxSubmit",
"searchboxAsYouType", "omniboxSearch", "omniboxAnalytics",
"omniboxFromLink", "omniboxField", "searchFromLink"}
Colleague Searches =
CALCULATE (
COUNT('Colleague Events'[SEARCH_ID]), ALLEXCEPT('Colleague Events', 'Colleague Events'[CAUSE2]), 'Colleague Events'[IsDesiredCause] = TRUE()
)
This gave the correct output
Best Regards
Saud Ansari
If this post helps, please Accept it as a Solution to help other members find it. I appreciate your Kudos!
Try this calculated column. The ALL calculate modifier is necessary to clear the filter context, and then apply the desired filter.
S =
CALCULATE (
COUNT ( 'Colleague Events'[SEARCH_ID] ),
ALL ( 'Colleague Events' ),
'Colleague Events'[CAUSE2]
IN {
"didyoumeanAutomatic",
"didyoumeanClick",
"searchboxSubmit",
"searchboxAsYouType",
"omniboxSearch",
"omniboxAnalytics",
"omniboxFromLink",
"omniboxField",
"searchFromLink"
}
)
Proud to be a Super User!
I tried unfortunately still getting the incorrect output
S =
CALCULATE (
COUNT ( 'Colleague Events'[SEARCH_ID] ),
FILTER (
'Colleague Events',
'Colleague Events'[Colleague Name]
= EARLIER ( 'Colleague Events'[Colleague Name] )
&& 'Colleague Events'[CAUSE2]
IN {
"didyoumeanAutomatic",
"didyoumeanClick",
"searchboxSubmit",
"searchboxAsYouType",
"omniboxSearch",
"omniboxAnalytics",
"omniboxFromLink",
"omniboxField",
"searchFromLink"
}
)
)
If the following information cannot meet your requirement, can you provide some sample output you want?
Best Regards!
Yolo Zhu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Also, please accept it as a solution for me.
The "Colleague Name" is from another column. However, I was able to resolve the issue by separating the filter.
IsDesiredCause =
'Colleague Events'[CAUSE2] IN {"didyoumeanAutomatic", "didyoumeanClick", "searchboxSubmit",
"searchboxAsYouType", "omniboxSearch", "omniboxAnalytics",
"omniboxFromLink", "omniboxField", "searchFromLink"}
Colleague Searches =
CALCULATE (
COUNT('Colleague Events'[SEARCH_ID]), ALLEXCEPT('Colleague Events', 'Colleague Events'[CAUSE2]), 'Colleague Events'[IsDesiredCause] = TRUE()
)
This gave the correct output
Best Regards
Saud Ansari
If this post helps, please Accept it as a Solution to help other members find it. I appreciate your Kudos!
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
Check out the June 2024 Power BI update to learn about new features.
User | Count |
---|---|
99 | |
93 | |
82 | |
64 | |
58 |
User | Count |
---|---|
248 | |
123 | |
112 | |
79 | |
78 |