cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
MonicaElizondo Regular Visitor
Regular Visitor

Help: how to show only some rows in the report

 

Hi!!

I have a question about how to show only some rows in the report,

 

I have the column Round, that is calculated from the column LC; with this function Round = IF(RIGHT(INT(J2),3)="000",1,0) and work fine.

 

 7.JPG

 

Now, I show in the report, only the values 1 from the column Round; and I want to show only 30 rows, actually i have a lot of rows, and only want show 30 order by quantity.

 

Thanks for your comments,

Monica

1 ACCEPTED SOLUTION

Accepted Solutions
Community Support Team
Community Support Team

Re: Help: how to show only some rows in the report

Hi MonicaElizondo,

 

I have made a mockup as below in which to achieve top3 by quality. You can firstly create a calculate column using DAX like this pattern.

Rank = RANKX(Table1, Table1[Quality], ,ASC ,Dense)

1.PNG 

Then create a measure using DAX like this pattern.

Round = IF(MAX(Table1[Rank]) <= 3, IF(RIGHT(ROUNDDOWN(MAX(Table1[LC]), 0), 3) = "000", 1, 0))

捕获.PNG  

 

Regards,

Jimmy Tao

3 REPLIES 3
Highlighted
Super User
Super User

Re: Help: how to show only some rows in the report

Hi @MonicaElizondo

 

In the visualization -> Fields Tab -> In visual filter, you can apply filter for 'Round'column.

 

For the TOP 30, in the same pane, select the Product column under visual filter -> In the filter Type-> Select TOP N and give 30 as value.

 

Thanks

Raj

Community Support Team
Community Support Team

Re: Help: how to show only some rows in the report

Hi MonicaElizondo,

 

I have made a mockup as below in which to achieve top3 by quality. You can firstly create a calculate column using DAX like this pattern.

Rank = RANKX(Table1, Table1[Quality], ,ASC ,Dense)

1.PNG 

Then create a measure using DAX like this pattern.

Round = IF(MAX(Table1[Rank]) <= 3, IF(RIGHT(ROUNDDOWN(MAX(Table1[LC]), 0), 3) = "000", 1, 0))

捕获.PNG  

 

Regards,

Jimmy Tao

MonicaElizondo Regular Visitor
Regular Visitor

Re: Help: how to show only some rows in the report

Hello!!

 

Thanks for the help!!