topic need help with DAX (Higher Education dashboard) in DAX Commands and Tips

need help with DAX (Higher Education dashboard)

jcogley — Mon, 03 Aug 2020 17:59:59 GMT

Hi,

I'm new to Power BI -- using to create an enrollment dashboard for Higher Education. Based on filter selections, the dashboard displays numbers of students retained and graduated. For privacy, I need to be able to return "Too Few" if the count of students falls below 10 for any given combination of selections.

This is the table unfiltered:

and this is after some filters were applied:

I started to use conditional formatting to hide numbers, but I'd really like a statement to return "Too Few" if any of the numbers fall below 10.

Any help is greatly appreciated!!

Thank you,

Julie

Re: need help with DAX (Higher Education dashboard)

Greg_Deckler — Mon, 03 Aug 2020 18:08:39 GMT

jcogley - Would think that you would have to do that within your measures themselves but that's probably going to cause some problems since you are return text and not a number and it looks like your measures are numeric. Not insurmountable but a pain.

Re: need help with DAX (Higher Education dashboard)

jcogley — Mon, 03 Aug 2020 18:37:00 GMT

Thanks Greg_Deckler. Appreciate it - will look to start there.

Re: need help with DAX (Higher Education dashboard)

Anonymous — Tue, 04 Aug 2020 09:45:43 GMT

Very easy actually. One measure would be the right measure that returns the real number and another measure would only be one that is for display purposes and based on the former one. The latter one, since it's a display measure, can return anything, even a mixture of types since YOU'RE NOT GOING TO USE IT ANYWHERE ELSE in any other formula. Easy.