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

The ultimate Microsoft Fabric, Power BI, Azure AI & SQL learning event! Join us in Las Vegas from March 26-28, 2024. Use code MSCUST for a $100 discount. Register Now

Reply
Gustavo98
Helper V
Helper V

Create a calculated table filtering by a measure

Hi,

 

How can i create a calculated table filtering this new table by a measure that i created?

 

 

1 ACCEPTED SOLUTION

I Solved using dax, ty everyone!

View solution in original post

6 REPLIES 6
Gustavo98
Helper V
Helper V

Thanks for your answers.

 

im going to be more specific. I have a table with columns of: Products, quantity sold, earnings. Also this table has geographical location, store where transaction was done, week, year etc...

 

 

 

In my pbi i have the following visual object: 

Gustavo98_0-1669031750717.png

First two columns from my visual objects are not measures, others columns are all measures. In yellow a measure that takes values of 1 oe 0 depending of another measure. y want to use this yellow column to create a calculated table, showing the rows only when "yellow" is 1.

 

My visual object is filtered showing just one product. I would like to have a table similar to my visual object, adding column product. I want that because in my visual obj i have a lot of usefull operations using previus rows for example.

 

thanks, if you need more details tell me.

 

 

 

 

 

v-xiaosun-msft
Community Support
Community Support

Hi @Gustavo98 ,

 

Calculated Tables are created at refresh time, while Measures are calculated at query time. After you create a calculated table, please establish a relationship between your fact tables and your calculated table, and then you can use a slicer to filter the new table.

 

Best Regards,
Community Support Team _ xiaosun

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

I Solved using dax, ty everyone!

The reaason why i want this is because i want to be able to calculate the function of a trend line that i get when i compare two measures that i have in my table. Maybe to do that is not necesary to all calculations again in a new calculated table?

 

Thanks everyone.

FreemanZ
Super User
Super User

Refering a measure in calculated table easily leads to confusion, as in most cases there are row context, hidden CALCULATE and thus context transition.

 

it would be better to provide a scenario with sample data and your expected result.

daXtreme
Solution Sage
Solution Sage

Helpful resources

Announcements
Fabric Community Conference

Microsoft Fabric Community Conference

Join us at our first-ever Microsoft Fabric Community Conference, March 26-28, 2024 in Las Vegas with 100+ sessions by community experts and Microsoft engineering.

February 2024 Update Carousel

Power BI Monthly Update - February 2024

Check out the February 2024 Power BI update to learn about new features.

Fabric Career Hub

Microsoft Fabric Career Hub

Explore career paths and learn resources in Fabric.

Fabric Partner Community

Microsoft Fabric Partner Community

Engage with the Fabric engineering team, hear of product updates, business opportunities, and resources in the Fabric Partner Community.

Top Solution Authors