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

Enhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.

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
July PBI25 Carousel

Power BI Monthly Update - July 2025

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

Join our Fabric User Panel

Join our Fabric User Panel

This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.

June 2025 community update carousel

Fabric Community Update - June 2025

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