Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago

Calculated Column

Hi, Based on the following diagram, I want to create the next calculated column, value, in the table INDICATOR based on two metrics and one variable: value=(deliveries/planedDeliveries)*...
Need Help
v-juanli-msft's avatar
v-juanli-msft
Icon for Community Support rankCommunity Support
7 years ago

Hi Anonymous 

You could create measures as below

sum_delivery = SUM(task[delivery])

sum_planned = SUM(task[planned delivery])

measure_value = ([sum_delivery]/[sum_planned])*SUM(indicator[weight])

 

Best Regards
Maggie

 

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

  • Anonymous's avatar
    Anonymous
    Not applicable
    7 years ago

    Hi v-juanli-msft ,

     

    Thanks for the answer, i already did those metrics, but the problem is that the metric:

    SUM(task[planned delivery])

     is giving me diferent values from the expect ones, when i calculate it in a custom column, i need to do this calculation in a custom column:

    ([sum_delivery]/[sum_planned])*SUM(indicator[weight])

    because i need to do further calculation based on the values of this column.

    It's strange because the sum(task[delivey]) is giving correct values, but the sum(task[planned delivey]) not, when calculated in the custom column.

     

    Do you have any idea why this is happening?

     

     

    • Anonymous's avatar
      Anonymous
      Not applicable
      7 years ago

      I just noticed what the problem is, i want to filter the Calculated Column:

      planned_Deliveries = SUM(task[planned delivery])

      In the report by Task[date], and it's not filtering (this column comes from SSAS).

       

      Is it possible to filter a Calculated Column from SSAS in Power BI?

      • v-juanli-msft's avatar
        v-juanli-msft
        Icon for Community Support rankCommunity Support
        7 years ago

        Hi Anonymous 

        When connect to SSAS with live connection, you could only create measure not columns, what you create in Power BI can't return back to SSAS.

         

        Best Regards
        Maggie

         

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