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

Get certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare now

Reply
aarshps
Frequent Visitor

APPLY FILTER ON CALCULATED TABLES

I have created a Calculated table using the max value of my Date dataset. And, I have a slicer on the Date.

 

I want my Calculated table to be filtered according to the Date slicer that I've been using. But as from I've read, Calculated tables are preprocessed before any slicers are applied.

 

Is there any other method to create a calculated column?

 

Can I create a List inside a dataset, or do you guys have any suggestion?

3 REPLIES 3
v-juanli-msft
Community Support
Community Support

Hi @aarshps

Which purpose do you make such trials for?  if you want to show max value of your dataset filtering by a slicer, you can create measures instead.

 

Best regards

Maggie

Ya, that's how I have done it. Inside each measure, I've created CalculatedTables and then used them. I was feeling like as I have multiple measures, won't it be costly or something? So I was thinking is there a way to creating a table like a measure, so that I can use it. Actually measure only return scalar values right? Instead is there a way to return a list or something? Also, this list can be used inside multiple measures? Just wanted to make sure, there are no such features available.

Hi @aarshps

For your requirement, I would recommend you to have a look at this article which introduces using variables within DAX.

You can use variables to create columns or tables both in measures or calculated columns.

 

Best Regards

Maggie

 

 

Helpful resources

Announcements
OCT PBI Update Carousel

Power BI Monthly Update - October 2024

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

September Hackathon Carousel

Microsoft Fabric & AI Learning Hackathon

Learn from experts, get hands-on experience, and win awesome prizes.

October NL Carousel

Fabric Community Update - October 2024

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