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,
Using the following sample data:
Date | Group | FILTER |
01-May-19 | A | Filter group 1 |
01-May-19 | A | Filter group 2 |
01-May-19 | A | Filter group 1 |
01-May-19 | B | Filter group 1 |
01-May-19 | B | Filter group 1 |
01-May-19 | B | Filter group 2 |
02-May-19 | A | Filter group 1 |
02-May-19 | A | Filter group 1 |
02-May-19 | A | Filter group 1 |
02-May-19 | A | Filter group 2 |
02-May-19 | A | Filter group 2 |
02-May-19 | A | Filter group 2 |
02-May-19 | B | Filter group 1 |
02-May-19 | B | Filter group 2 |
03-May-19 | A | Filter group 2 |
03-May-19 | A | Filter group 2 |
03-May-19 | B | Filter group 1 |
03-May-19 | B | Filter group 1 |
03-May-19 | B | Filter group 2 |
03-May-19 | B | Filter group 2 |
I want to be able to create a table that looks like this:
Date | Group | Count of Group & date | Total count by date only |
2019/05/01 | A | 3 | 6 |
2019/05/01 | B | 3 | 6 |
2019/05/02 | A | 6 | 8 |
2019/05/02 | B | 2 | 8 |
2019/05/03 | A | 2 | 6 |
2019/05/03 | B | 4 | 6 |
I am particularly interested in getting the values for the last column. I suppose one would need to create a DAX measure. How can one go about doing so?
Solved! Go to Solution.
hi, @pieterhkruger
Just try this formula to add a measure
Measure = CALCULATE(COUNTA(Table1[Group]),ALLEXCEPT(Table1,Table1[Date]))
Result:
Best Regards,
Lin
hi, @pieterhkruger
Just try this formula to add a measure
Measure = CALCULATE(COUNTA(Table1[Group]),ALLEXCEPT(Table1,Table1[Date]))
Result:
Best Regards,
Lin
Use countrows on the table the same way you'd make the first column, but you want to apply allexcept to the date column - this'll make the calculation disregard the group (and anything else for that matter) but still split it by date
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 |
---|---|
115 | |
100 | |
88 | |
69 | |
61 |
User | Count |
---|---|
151 | |
120 | |
103 | |
87 | |
68 |