Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now! Learn more

Reply
azaterol
Helper V
Helper V

DAX: Countrow Filter for table

Hello all,

 

I want create a DAX-Filter that count the rows in the above table. The reason is, that I want put the second table directly under the first table if there are 5 rows or less in the first table. Thats because if I filter the orders by date with the slicer, I got less rows than before, but the same table size. 

With bookmarks I can use the DAX-Filter, that I put in the first table to count the rows.

If the rows under 5 or 5, the second table should move directly unter the first table last row(so the height of the first table should now be smaller that before).I want avoid the big white blanks unter the first table, if I use the date filter and the output give me less rows.

 

Here is the sample.
https://easyupload.io/4lwhqv

 

sample1.PNG

 

 

 

 

 

 

 

 

 

 

 

sample2.PNG

 

 

 

 

 

 

 

Thank you for any help.

7 REPLIES 7
lbendlin
Super User
Super User

You cannot influence the size or position of visuals with measures.  Bookmarks are your only choice for now.

@lbendlin  thank you for your answer. I know that just bookmarks will help me here.
But I have no idea how? Maybe you can show me how in my sample data which I upload? 

see attached.

@lbendlin  this Data is the same as mine...

I cant find your work. You have upload the correct pbix file?

 

Thank you!

You may not have noticed that I have duplicated one of the visuals...  Check the bookmarks and switch between bookmark1 and bookmark2

@v-kkf-msft  there is no correct solution... you marked it as accept.

Unmarked 

Helpful resources

Announcements
Power BI DataViz World Championships

Power BI Dataviz World Championships

The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now!

December 2025 Power BI Update Carousel

Power BI Monthly Update - December 2025

Check out the December 2025 Power BI Holiday Recap!

FabCon Atlanta 2026 carousel

FabCon Atlanta 2026

Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.