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

Join the Fabric FabCon Global Hackathon—running virtually through Nov 3. Open to all skill levels. $10,000 in prizes! Register now.

Reply
Syndicate_Admin
Administrator
Administrator

Create a table based on the value of a filter

Hello

I have the following elements:
Table1 | DATE DAY | destiny
Control variable TRUE or FALSE
it is possible to create a new table according to the state of the variable if true copy the data from table1 if false leave the fields blank

It's possible?

2 REPLIES 2
AlexisOlson
Super User
Super User

Calculated tables cannot be responsive to slicers or report filters since they are only computed once each time the data is loaded rather than whenever you change filters on a report.

Fowmy
Super User
Super User

@Syndicate_Admin 
Can you share some sample data with the desired output to have a clear understanding of your question? Mention whether you want a calculated column or measure
You can save your files in OneDrive, Google Drive, or any other cloud sharing platforms and share the link here.


Did I answer your question? Mark my post as a solution! and hit thumbs up


Subscribe and learn Power BI from these videos

Website LinkedIn PBI User Group

Helpful resources

Announcements
September Power BI Update Carousel

Power BI Monthly Update - September 2025

Check out the September 2025 Power BI update to learn about new features.

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.

Top Solution Authors
Top Kudoed Authors