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

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
craigmon's avatar
craigmon
Helper I
11 months ago

this worked perfectly, many thanks for your help