Hi everyone.
I have a table on a report that consists of manufacturer, manufacturer-customer, sales prior 6 months, sales last month, eGM % past 6 months, eGM % last month, manager, their manager.
I am trying to create a field that is the eGM % for the individual manufacturer for the past 6 months. This field should show the same number for all of the manufacturer-customer, but it should be different for each manufacturer.
Right now I have calculate([eGM%], FILTER (past 6 months), ALLEXCEPT('sales', manufacturer), FILTER('sales', [type] = "new" || [type] = "current"). It is showing correctly on a card, but it displays as 0 on the table. I need it to work because I want to make another measure off of it. (customer eGM - manufacturer eGM).
Also, it works almost completely correctly if I remove the last FILTER for type.
Anyone know a way to fix it or a work around?
