Forum Discussion

Faracla's avatar
Faracla
Frequent Visitor
3 years ago

Visualization Table not keeping fix value per row

Dear all
I'm stuck in a problem with my visualization table in power bi (below screen)



I created a calculate column called "ValueToDivide" which is the result of the total accepted load / 100,in this example the result is 4.31.

 

Issue: when I drag "ValueToDivideinto" into the table what I want to see per each row is always 4.31 while this changes each time.

ValueToDivide must be a fix value that I need in order to calculate other 2 columns:

 

WeightShare: Accepted load / ValueToDivide
FinalWeightShare: WeightShare*ShareFullMonth

Due to the "ValueToDivide"not being a fix value, the other 2 colums are giving me total wrong results

 

Basically the end result I want to achieve is

First : to divide each row value of the accepted load against "ValueToDivide"

Second: the result of it must be multiplied per each value of the "ShareFullMonth" column

Below screen of  the wanted result in green 

 

 

Is there a way to achieve this?
thank you 

Claudio
 

Need Help

2 Replies

  • nvprasad's avatar
    nvprasad
    Solution Sage
    3 years ago

    Hi,

     

    If have to ignore filters coming from other attributes within this table visual using All functions.

     

    I am ignoring fitlers from Sales table by using All function to get desired output. please refer above snapshot.

    Sales_By_Order_V2 = CALCULATE(DIVIDE([M_Sales], [OrderCount],0),ALL(Sales))
     

    Appreciate a Kudos! ‌‌
    If this helps and resolves the issue, please mark it as a Solution! ‌‌

    Regards,
    N V Durga Prasad

  • Faracla's avatar
    Faracla
    Frequent Visitor
    3 years ago

    Hi nvprasad 
    First of all, thanks for taking the time to answer to my question, that exactly the result i'm trying to achieve but unfortunately did not work in my case
    i have tried your code as per below:

    ValueToDivide = CALCULATE(DIVIDE(DIM_Tenders[_Accepted_load],100),ALL(DIM_Tenders))

    The "ValueToDivide" column still do not show a fix value of 4.31,screen below

     

     

    Do you know how to get it solved?
    If you need more info , don't hesitate to ask

    thank you 

    Claudio