Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago

Filter Calculated Column from SSAS

Hi,

 

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

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?

Need Help

5 Replies

  • v-diye-msft's avatar
    v-diye-msft
    Community Support
    7 years ago

    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

    • Anonymous's avatar
      Anonymous
      Not applicable
      7 years ago

      Hi v-diye-msft ,

       

      I work On-Premisses, is that applicable too?

       

      Best Regards

      • v-diye-msft's avatar
        v-diye-msft
        Community Support
        7 years ago

        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.