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.
Hello,
I am struggling to write a DAX Calculation to report the number of records that qualify based on multiple components.
I have tried to use the "OR" function several different ways and the only one I can get to work provides me with the incorrect count. (code below)
I know I should have 19 qualified lines using this logic.
Opportunity Solution = X and Created Date Year = 2020
Plus
Opportunity Solution = Y and Created Date Year = 2020
However, based on the below code I receive the count of 63.
Solved! Go to Solution.
Try this one :
Try this one :
Hello @Matt0515 ,
Try this:
Measure 2020 =
VAR _Filter2020 =
FILTER('Table',
'Table'[Created Date Year] = 2020
)
VAR _Count =
CALCULATE(
COUNTROWS('Table'),
_Filter2020,
'Table'[Opportunity Solution] = "X" || 'Table'[Opportunity Solution] = "Y"
)
RETURN
_Count
Cheers!
Vivek
If it helps, please mark it as a solution
Kudos would be a cherry on the top 🙂
https://www.vivran.in/
Connect on LinkedIn
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 |
---|---|
49 | |
26 | |
21 | |
16 | |
12 |
User | Count |
---|---|
57 | |
49 | |
44 | |
19 | |
18 |