DAX filer to show more than 10 rows

[Anonymous]

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

[Anonymous]

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

[Anonymous]

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!

[Stachu · Accepted solution]

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)

[Anonymous]

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!