Forum Discussion

Take2's avatar
Take2
Regular Visitor
3 years ago
Solved

SUM Only Specified Values For All Higher Matrix Levels

Hello -    Here is the link to the PBIX:  https://drive.google.com/file/d/1vdZmj0n0-JpCXnQ6kqTgxxjGW_8x-rx8/view?usp=drive_link   The following Rows exist in the below Matrix: - SalesRep Name ...
  • tamerj1's avatar
    tamerj1
    3 years ago

    Take2 
    Hi Nathan. Apologies for the late response. I really didn't have the time to look into it. Please look at the proposed solution below

    Type 2 V2 New = 
VAR Type1Exists = NOT ISBLANK ( [Type 1] )
VAR Type2AllQuarters =
    SUMX ( 
        SUMMARIZE ( 
            Data,
            SalesRep[SalesRep Name],
            Customer[Customer Name],
            'Product'[Product Name]
        ),
        CALCULATE (
            [Type 2],
            REMOVEFILTERS ( 'Calendar'[Year Quarter Number] )
        )
    )
VAR Result = 
    IF ( Type1Exists, Type2AllQuarters )
RETURN 
    Result
Take2's avatar
Take2
Regular Visitor
3 years ago

OK, so it looks like I still need help.  My solution in the previous post only works on the dummy data set I created for sharing.  However, when I try to add the same simple measure to the matrix in the REAL report, the Matrix just spins endlessly (more than 10 minutes), and Performance Analyzer just spins as well.

 

The spinning starts the instant I attempt to add the measure [z2 Totals] to the Matrix.

 

 

 

After spinning for 15 minutes, the matrix eventually fails:

"Cannot display the visual.  See Details."

 

 

I am confused how this can be running out of memory.

In the current FC (Filter Context), there are only 3 values for 'DimProduct STAGE'[PRODUCT_CODE] over which I want to be iterating.  So how am I running out of memory?

1) $18.89

2) $4.58

3) $6.87

 

If anyone can help me fix the measure so that it only handles the PRODUCT_CODE values displayed, I would greatly appreciate it.  This measure should take less than a second to process the resul.  So clearly my measure is very wrong....at least when performed against the real data set.

 

Thank you