Forum Discussion

APM's avatar
APM
Helper I
3 years ago

Values change (become incorrect) when pulled into a Matrix visual (VS correct in Card visual)

Hello,   I have a major issue: My measures pull correct data. They also pull correct data when filtered, in my case by 'Category'.   However, when I pull them into a matrix table, sometimes, the ...
Need Help
Tutorial Requests
Anonymous's avatar
Anonymous
Not applicable
3 years ago

Hi APM ,

 

If you want to ignore the other filters and keep the filter grouping of the directory, you can modify it to the following:

L7D $ LY =
CALCULATE (
    SUM ( 'TEST REPORT'[Fake_Sales_Data] ),
    FILTER (
        ALLSELECTED ( 'TEST REPORT' ),
        [Category] = MAX ( 'TEST REPORT'[Category] )
            && 'TEST REPORT'[Date]
                >= TODAY () - 372
            && 'TEST REPORT'[Date]
                <= TODAY () - 366
    )
)

 

   

                                                                                                                                                         

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.