Forum Discussion
DAX Percentage Range
Yes, there's a difference between the actual underlying numerical value and the way it's displayed (Format).
It sounds like you need to round the value to the nearest 0.0001 before displaying it in the chart.
here's the ROUND function, and an example of what the measure or new column should look like. All you need to do is put in the integer corresponding to how many digits after the decimal point you want to round, (sounds like 4 is the right number for you, 4 places after the decimal).
https://learn.microsoft.com/en-us/dax/round-function-dax
Statistical Attendance Presence Below Target % =
var attendance = ROUND('MIS: Attendance'[Statistical Attendance Presence %] , <put integer here>)
return
IF(attendance >= 0.90 && attendance <= 0.93, attendance, BLANK())
//Mediocre Power BI Advice, but it's free//
Thanks for your reply. I've double-checked and the figure is a percentage at 2 decimal places. The actual value for a student in the table is 93.001345895, but because i only want 2 decimal places it should show this record in the table as it equals 93%. Am I missing something simple? I have even tried removing the measure and using the filter's visual panel to see if that filter works, but it is doing exactly the same.
kpostSolution Sage
Yes, there's a difference between the actual underlying numerical value and the way it's displayed (Format).
It sounds like you need to round the value to the nearest 0.0001 before displaying it in the chart.
here's the ROUND function, and an example of what the measure or new column should look like. All you need to do is put in the integer corresponding to how many digits after the decimal point you want to round, (sounds like 4 is the right number for you, 4 places after the decimal).
https://learn.microsoft.com/en-us/dax/round-function-dax
Statistical Attendance Presence Below Target % =
var attendance = ROUND('MIS: Attendance'[Statistical Attendance Presence %] , <put integer here>)
return
IF(attendance >= 0.90 && attendance <= 0.93, attendance, BLANK())
//Mediocre Power BI Advice, but it's free//I tried your solution this morning and it worked!!! I'm so grateful for your response. It was driving me mad and I couldn't see what I had done. A massive thank you once again.