Forum Discussion

craigmon's avatar
craigmon
Helper I
11 months ago
Solved

Help with complex Measures and Calculated columns

Hi Guys,   I'm trying to achive the same as the attachment which in excel, but in Power BI.  I'm really struggling to get these to duplicate, esepcially getting a total of the Negative Values.  Can...
Need Help
  • raji_n's avatar
    raji_n
    11 months ago

    Hi craigmon 

    Please use these measures,
    1. 

    Measure = sumx(SUMMARIZE(Dealbook,Dealbook[Location1],Dealbook[Sales Exec],"x",[01 Negative Diff Only Measure]),[x])

    2. 

    01 Neg Diff Only Measure New = if([01 PPU Diff  Measure]<0,[01 PPU Diff  Measure],if(HASONEVALUE(Dealbook[Location1]),[Measure])) --- add this to your visual to get the values
     
    Please mark this as solution if it resolves your problem
    Thanks,
    Rajashri N
raji_n's avatar
raji_n
Resolver II
11 months ago

Can you please share a mock excel data craigmon 

for column e,g you can use divide function in DAX

Column h, use all function to return the average value, 

 

Column i cna use the * operator to multiply

Column k, do an if loop to check for negative values, IF([YourColumnName] < 0, [YourColumnName],0)

Cell k14, do a sum by applying abs()

Let me know if this helps.