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
Hi there - PowerBi newbie here:
Could anybody highlight the error in my DAX expression below:
I am trying to count the number of people in 'people' with auditlogs all'[Description] containing either "Sent Retake" or "Sent Redo"
I get no immediate error in the dax formula bar but when i try to add the measure to a visual i get the following error:
Any help would be appreciated.
Solved! Go to Solution.
Could you try:
No of people with retakes = CALCULATE(DISTINCTCOUNT('people (2)'[Person ID]), FILTER('auditlogs all',CONTAINSSTRING('auditlogs all'[Description], "Sent Retake") || CONTAINSSTRING('auditlogs all'[Description], "Sent Redo")))
The "||" operator represents OR in DAX. "&&" can be used for AND
This worked - thank you!
Could you try:
No of people with retakes = CALCULATE(DISTINCTCOUNT('people (2)'[Person ID]), FILTER('auditlogs all',CONTAINSSTRING('auditlogs all'[Description], "Sent Retake") || CONTAINSSTRING('auditlogs all'[Description], "Sent Redo")))
The "||" operator represents OR in DAX. "&&" can be used for AND
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 |
---|---|
101 | |
94 | |
80 | |
63 | |
56 |
User | Count |
---|---|
247 | |
122 | |
110 | |
77 | |
72 |