Power BI Exchange

Please login or click SIGN UP FOR FREE to create your PowerBIUG account to join this user group.
 View Only
  • 1.  Absolute error in Actuals & Forecast

    Posted 11 days ago

    Hi Guys,

    I have a scenario. I have a table & I want to show the data by article level. Here I am getting the difference is 10 but I want the output is 30 on total. 

    Srikantht_0-1659042824643.png

     I wrote the below measure but I got 80 (I think 8 articles*10) is the output

     

    =SUMX(VALUES(Article[Article]) ,CALCULATE(ABS(sum(Forecast)-sum(Actual))).

     

    any one help me ? How do i write a measure to get the output is 30 ?

     

    Thanks in advance. 



    ------------------------------
    Sreekanth T
    Software developer
    Bangalore SD
    ------------------------------


  • 2.  RE: Absolute error in Actuals & Forecast

    Posted 9 days ago
    Tente
    Abs Diff =
    SUMX (
        VALUES ( Article[Article] ),
        CALCULATE ( ABS ( SUM ( Article[Actual] ) - SUM ( Article[Forecast] ) ) )
    )​


    ------------------------------
    Vilmar Santos
    ------------------------------



  • 3.  RE: Absolute error in Actuals & Forecast

    Posted 9 days ago
    Thank you Vilmar.

    It's Working...

    ------------------------------
    Sreekanth T
    Software developer
    Bangalore SD
    ------------------------------