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

Don't miss out! 2025 Microsoft Fabric Community Conference, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount. Prices go up February 11th. Register now.

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
Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Prices go up Feb. 11th.

Jan25PBI_Carousel

Power BI Monthly Update - January 2025

Check out the January 2025 Power BI update to learn about new features in Reporting, Modeling, and Data Connectivity.

Jan NL Carousel

Fabric Community Update - January 2025

Find out what's new and trending in the Fabric community.