Dynamic groups matrix

[Anonymous]

Hi 

I have a measure that is working when used in a table. However I want to use it in a matrix but that is not working.

I get the message: "A table of multiple values was supplied where a single value was expected". 

Any who have an idea how to fix this? 

The measure:

Revenue Sum =
IF(
    HASONEVALUE('Client Rev.'[Min]);
        CALCULATE(
            'Data'[Revenue];
             FILTER(
             'Unique customers';
                [Client_revenue] >= VALUES('Client Rev.'[Min]) &&
                [Client_revenue] < VALUES('Client Rev.'[Max]));
                 		FILTER(
				'Unique customers';
                			[Revenue by size] >= VALUES('Revenue'[Min]) &&
                			[Revenue by size] < VALUES('Revenue'[Max]))
                
        )
        ;
    'Data'[Revenue])

A table to the left and a matrix to the right with the same measure and columns: 

[richbenmintz · Accepted solution]

@Anonymous ,

It look like you have not gaurded against multiple values for 

'Revenue'[Min] and 'Revenue'[Max], try the formula below

Revenue Sum =
IF(
    HASONEVALUE('Client Rev.'[Min]) && HASONEVALUE('Revenue'[Min])  && HASONEVALUE('Revenue'[Min]); 
        CALCULATE(
            'Data'[Revenue];
             FILTER(
             'Unique customers';
                [Client_revenue] >= VALUES('Client Rev.'[Min]) &&
                [Client_revenue] < VALUES('Client Rev.'[Max]));
                 		FILTER(
				'Unique customers';
                			[Revenue by size] >= VALUES('Revenue'[Min]) &&
                			[Revenue by size] < VALUES('Revenue'[Max]))
                
        )
        ;
    'Data'[Revenue])

[Anonymous]

@richbenmintz  Great! Thnx!