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
Anonymous
Not applicable

Filter Calculated Column from SSAS

Hi,

 

I'm having trouble filtering a calculated column from SSAS in Power BI, considering the following image:

Task_Indicator 3.jpg

I want to calculate the sum of the Task[planed_Delivery] for each Indicator and multiply it by the weight in a Calculated Column (Indicator[planned_Deliveries]) to do further calculations with that column.

planned_Deliveries = SUM(Task[planed_Delivery])

The problem is that i want to filter this calculated column by Task[date] in the Dashboard, but it doesn't filter by date in the Dashboard, when i apply the filter it gives me the total result, as the filter has not been applied.

 

Can calculated columns from SSAS be filtered in Power BI? If it's possible what i'm i doing wrong?

5 REPLIES 5
v-diye-msft
Community Support
Community Support

Hi @Anonymous ,

 

Can you filter the report successfully in report view in service? if it works well, you can pin the whole report page to dashboard to make sure the filter working well.  note that you can't pin the visual one by one.

 

Best regards,

Dina Ye

Community Support Team _ Dina Ye
If this post helps, then please consider Accept it as the solution to help the other members find it more
quickly.
Anonymous
Not applicable

Hi @v-diye-msft ,

 

I work On-Premisses, is that applicable too?

 

Best Regards

Hi @Anonymous ,

 

Sorry i am not quitely get you, the problem is that you can't use the filter in dashboard, right? but before you pin it on the dashboard, there must be a report in your workspace. if the filter can work well in the report, once you pinned the whole page to dashboard, the filter works well, too. 

 

Figuring that you have modeled the report in desktop, and next you'll publish it to service. please follow the advice and try again.

Community Support Team _ Dina Ye
If this post helps, then please consider Accept it as the solution to help the other members find it more
quickly.
Anonymous
Not applicable

Hi @v-diye-msft , 

 

Sorry i did not explain well, i don't use service, i use the on-premisses solution with SSAS and PBIRS, and i can't filter the calculated column in the report in Power BI even before publishing it to PBIRS.

 

I think the problem is that custom columns created in SSAS can't be filtered in Power BI, by other tables dimensions. 

 

Thanks 

Hi @Anonymous ,

 

Would you mind sharing me your dummy pbix? upload it to Onedrive/Sharepoint/Dropbox, and generate the share link. Make sure you've removed the confidential info before.

 

Best regards,
Dina Ye

Community Support Team _ Dina Ye
If this post helps, then please consider Accept it as the solution to help the other members find it more
quickly.

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.