topic DAX filer to show more than 10 rows in DAX Commands and Tips

DAX filer to show more than 10 rows

Anonymous — Wed, 07 Aug 2019 13:26:51 GMT

Hello,

I am trying to make a DAX expression to use DAX filer to show more than 10 rows?

DEFINE MEASURE SCHOOL[OrdersMeasure] = COUNTROWS(ORDERS)>10
EVALUATE
ROW("Column1",SCHOOL[OrdersMeasure] )

How can I use True and False here? If less than 10 rows print a message and if more than 10 show all rows.

Thanks

Re: DAX filer to show more than 10 rows

Stachu — Sun, 11 Aug 2019 04:35:10 GMT

I'm not sure what you try to achieve, can you elaborate?

In general - measure can only return a scalar value, so it will never return 10 rows. It could return concatenated rows, e.g. by using CONCATENATEX but then you basically convert a table to scalar. Currently yur measure returns TRUE/FALSE depending on the number of rows in the ORDERS table - is that what you want it to return?

IF can also only return a scalar (not a table), so I don't think it's applicable here

do you want to create a model, or to query the model by writing custom queries? If you use PowerBI as UI for your users then there is no need for that (unless you want to create calculated tables)

Re: DAX filer to show more than 10 rows

Anonymous — Mon, 12 Aug 2019 09:24:56 GMT

Mate, remember that visuals HIDE ROWS where all the measures are BLANK. This should give you enough information about how to show the rows you want... If you still see rows where all the measures are BLANK, then you should uncheck the option somewhere in the visual that enables this behaviour.

Best
Darek

Re: DAX filer to show more than 10 rows

Anonymous — Mon, 12 Aug 2019 12:16:41 GMT

Thank you for your reply. I came to same conculsion.

IF can also only return a scalar (not a table), so I don't think it's applicable here

I using business suppression rules on database level now so if some business rule is not met it displays a custom message.

Thank you very much!

Re: DAX filer to show more than 10 rows

Anonymous — Mon, 12 Aug 2019 12:24:05 GMT

Thank you for your reply! I got a new requirement to also add custom messages at all levels, database or PowerBI, so I just went with applying the business rules at database level. Thanks again!