Forum Discussion

mrothschild's avatar
mrothschild
Icon for Continued Contributor rankContinued Contributor
5 years ago

Matrix sub-total rows not seemingly numerically associated with underlying data

PBIX FILE: https://drive.google.com/file/d/1j_4CrUj0fPh0xK6hnO7OZ-uIWkoP5Kdg/view?usp=sharing ________________________________________________ ***UPDATE*** Identified one of the offending measures...
Need Help
Anonymous's avatar
Anonymous
Not applicable
5 years ago

Hi mrothschild ,

 

Sorry, I did not particularly understand your question. What is your expected result? Your data is too large for me as a stranger. Can you simplify the problem, give a simple sample data and expected results, I will help you as much as possible.

 

Best Regards,

Stephen Tao

 

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

  • mrothschild's avatar
    mrothschild
    Icon for Continued Contributor rankContinued Contributor
    5 years ago

    Anonymous 

     

    Here is a cleaned-up version of above: https://drive.google.com/file/d/12_k_tO8BdrXV73Lbho_whabGP-jOlasP/view?usp=sharing

     

    The tab in question is "Troubleshooting for forum help".  The intent is to have the cells/values in the bottom matrix equal the columnar average of the above Matrix.  As shown in the screenshot below, the "Aggregated Model" slicer located on the left hand of the dashboard in the middle (from top to bottom) has selected only "EC-135".

     

     

    The current programming I'm attempting to use that generates the [measure] for the lower Matrix is: 

    Upside (averaged within a given sale year for graph output) = 

VAR OUTPUT = 
        AVERAGEX( 
            ADDCOLUMNS (
                SUMMARIZE (
                    ALLSELECTED ('Helivalues Transaction History'[Sale Year]),
                    'Helivalues Transaction History'[Sale Year],
                    "COUNT", COUNT ( 'Helivalues Transaction History'[Year of Build] )
                ),
                "__Output", [Upside (Graph)]  
            ),
            [__Output]
)


RETURN
    
    OUTPUT