locked
Accuracy Calculation Powerpivot RRS feed

  • Question

  • Hi,

    I have been working on this to make it clearer. On the powerpivot tab 'accuracy' you will see the measures that relate to the excel page 'MAPE by Area'. I have done stage one as you advised building 'Mapemeasure' to measure accuracy and then Gradearea average which brings back straight averages as we discussed.

    I have now tried to apply weighting, I want to apply weighting to everything above grade in the row labels so that is family, vendor and area. In accuracy measure you will see my attempt to do this and the weightings but it has failed - I hope this helps you understand my issue more, let me know if not and I will see what I can do.

    https://onedrive.live.com/redir?resid=3AE8882B3E11F58!119&authkey=!ABqtkoPSKxaYXTo&ithint=file%2cxlsx

    Many thanks

    Tuesday, January 6, 2015 4:38 PM

Answers

  • This thread is a continuation of another.

    The original request was for the weighting to be baked into the measure definition:

    SomeMeasure:=
    SUMX(
        SUMMARIZE(
            FRCReport
            , FRCReport[Family]
            , FRCReport[Grade]
        )
        , CALCULATE( AVERAGE( FRCReport[SomeColumn] ) )
            * SWITCH(
                   FRCReport[Family]
                   , "Fruit"
                   , SWITCH(
                       FRCReport[Grade]
                       , "A", .5
                       , "B", .3
                       , "C", .2
                   )
                   , "Vegetable"
                   , SWITCH(
                       FRCReport[Grade]
                       , "A", .7
                       , "B", .2
                       , "C", .1
                   )
               )
    )

    This was wrapped in another measure:

    ConditionalSomeMeasure:=
    IF( 
        HASONEVALUE( FRCReport[Item Code] )
        , MAX( FRCReport[SomeColumn] )
        , [SomeMeasure]
    )

    Things have picked up for me at work and I've not been able to continue the dialogue with Grinch356.

    The measures above and the linked thread should help to give some useful context for this thread.

    You can safely ignore the large walls of text below any of my posts in that thread, as those are just detailed explanations of how the functions work in each measure.

    Wednesday, January 14, 2015 3:37 PM

All replies

  • Hi Grinch356,

    Could you help to clarify this further by walking us through an example of how the weighting should work?


    Regards,

    Michael Amadi

    Please use the 'Mark as answer' link to mark a post that answers your question. If you find a reply helpful, please remember to vote it as helpful :)

    Website: http://www.nimblelearn.com, Twitter: @nimblelearn

    Wednesday, January 14, 2015 10:09 AM
  • This thread is a continuation of another.

    The original request was for the weighting to be baked into the measure definition:

    SomeMeasure:=
    SUMX(
        SUMMARIZE(
            FRCReport
            , FRCReport[Family]
            , FRCReport[Grade]
        )
        , CALCULATE( AVERAGE( FRCReport[SomeColumn] ) )
            * SWITCH(
                   FRCReport[Family]
                   , "Fruit"
                   , SWITCH(
                       FRCReport[Grade]
                       , "A", .5
                       , "B", .3
                       , "C", .2
                   )
                   , "Vegetable"
                   , SWITCH(
                       FRCReport[Grade]
                       , "A", .7
                       , "B", .2
                       , "C", .1
                   )
               )
    )

    This was wrapped in another measure:

    ConditionalSomeMeasure:=
    IF( 
        HASONEVALUE( FRCReport[Item Code] )
        , MAX( FRCReport[SomeColumn] )
        , [SomeMeasure]
    )

    Things have picked up for me at work and I've not been able to continue the dialogue with Grinch356.

    The measures above and the linked thread should help to give some useful context for this thread.

    You can safely ignore the large walls of text below any of my posts in that thread, as those are just detailed explanations of how the functions work in each measure.

    Wednesday, January 14, 2015 3:37 PM