Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Update - BUG - Matrix grouping breaking while live.

Hi all,

 

I was wondering if it is possible to calculate the delta of two different snapshots, without breaking grouping in a matrix?

 

I have the calculation currently as follows:

 

New sale =
CALCULATE(Sum(amount]),FILTER((salesforce), Salesforce[SNAPSHOT_DATE] = MAX(Salesforce[SNAPSHOT_DATE]) && Salesforce[Pipeline Opportunity Type] = "New" && Salesforce[IS_CLOSED] = FALSE())
-
CALCULATE(Sum(Salesforce[AMOUNT_MST_CURRENCY_ACTUAL]),FILTER((Salesforce), Salesforce[SNAPSHOT_DATE] = MIN(Salesforce[SNAPSHOT_DATE]) && Salesforce[Pipeline Opportunity Type] = "New" && Salesforce[IS_CLOSED] = FALSE()))
 
The problem with this measure is that it breaks the grouping of dimensions in a matrix:
 
In the example, user TIM belongs to only store A, but Tim is showing up in STORE B as blank (Due to the calculate () - calculate)
 
Snapshot Date filter
24-08-2019  -  28-08-2019
Matrix:
Store:     User:           VALUE
A             TIM               100.00
                JANE              BLANK
B             TIM                BLANK
               JANE             2000.00
 
Need Help

1 Reply

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    After some investigation,

    I re-created the exact same table (New Matrix, dragged columns and measures in) and the matrix grouping was working as expect. This seems like a powerbi Bug.

     

    Update - the matrix is once against broken for no reason in production.

     

    This has happened a couple times now.