Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
8 years ago
Solved

Using SUM in a Calculated Column returns unexpected results

Hello, I thought I had a good understanding of Context Evaluation in DAX (I hope I still do) but ran into this scenario   As an example I have a very simple table Imported into Power BI Desktop fr...
Need Help
  • sqlguru448's avatar
    sqlguru448
    8 years ago

    Under visualization pane in the values Click on the "ratio" column and click on the last value "show value as"  and click percent of grand total.

     

    This should give you the desired result.

     

    Thanks

sqlguru448's avatar
sqlguru448
Helper III
8 years ago

Hi Anonymous

 

Instead of creating Calculated column for Total Revenue, try to create calculated measure.By doing so you can see 600 when you apply slicers/filters.

 

Thanks

Anonymous's avatar
Anonymous
Not applicable
8 years ago

Thanks for the quick response.

 

Eventually what I want to do is take the Revenue and Divide it by the Total_Revenue_Col for each row in order to the get the % for the selected Region.

 

In this case the if I create the Measure as the SUM of the Revenue column and drag into the table it will still be equivalent to the Revenue field due to the context created by the surrouding area.

 

I am wondering why the logic with the Calcualted Column using the SUM does not work as expected.  I've seen it documented in several places that it should work, I.e., the value from the Slicer gets applied to the table containing the data and then the Calcualted Column expression is executed on what is returned.