The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
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