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.
Good day,
I've used other BI tools but am relatively new to Power BI. Here's my challenge.
I created a lookup table that can be used in the calculation.
Elementary Attendance Days Absent Range
Here's the DAX expression I'm trying to use. Note that [Elementary Attendance Students] is a distinct count of student numbers.
Days Absent Range = VAR AgeRangeDimension = VALUES('D: Student'[OEN]) RETURN CALCULATE ([Elementary Attendance Students], FILTER ( AgeRangeDimension, COUNTROWS( FILTER('Elementary Attendance Days Absent Range', RANKX( ALL ('D: Student'[OEN] ), 'M: Elementary Attendance'[Days Absent], , DESC ) > 'Elementary Attendance Days Absent Range'[Min Days] && RANKX(ALL ('D: Student'[OEN] ), 'M: Elementary Attendance'[Days Absent], , DESC ) <= 'Elementary Attendance Days Absent Range'[Max Days] ) ) > 0 ) )
When I use this column in a dashboard, I just get the value of large number which I beliegve is just summing all of the stduents. Here are the questions that I'm hoping you can help with.
Thanks a lot for your help;
Dave
Solved! Go to Solution.
You may refer to the following post.
https://community.powerbi.com/t5/Desktop/Create-a-bar-graph-with-measures-as-axis/td-p/455900
You may refer to the following post.
https://community.powerbi.com/t5/Desktop/Create-a-bar-graph-with-measures-as-axis/td-p/455900
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 |
---|---|
14 | |
2 | |
2 | |
1 | |
1 |
User | Count |
---|---|
21 | |
2 | |
2 | |
2 | |
2 |