Strange behavior for a mesure and table

[Anonymous]

Hi all,

I want to put you in situation. For a project, I'm changing the excel with power pivot to power bi. I'm trying to use the same parameters, measures, tables, datasources etc... In the way to do I'm suffering an error with a measure. the error is that:

The thing is in the excel file I'm not sure if is a measure or calculate column. I tested with both cases and the error is the same that I paste before.

The measure that I'm using is:

Color Rentabilidad Flex = if([TotalBrutoRentabilidad]>0;CALCULATE ( VALUES ( 'TramosRentabilidad'[sDescripcion] );FILTER ( 'TramosRentabilidad'; ([Rentabilidad]*100) >= 'TramosRentabilidad'[fValMinTramo]  && ([Rentabilidad]*100) < 'TramosRentabilidad'[fValMaxTramo] )))

[Anonymous]

I think , the wrong here is the "Values" parameter the description of the "Values" parameter is "Returns a one-column table that contains the distinct values from the specified table or column. In other words, duplicate values are removed and only unique values are returned." 

Someones knows any other command instead of "Values"?

[v-cherch-msft · Accepted solution]

Hi @Anonymous 

You may try to use aggregated function like MIN,MAX...to instead of VALUES.For example:

Color Rentabilidad Flex =
IF (
    [TotalBrutoRentabilidad] > 0,
    CALCULATE (
        MAX ( 'TramosRentabilidad'[sDescripcion] ),
        FILTER (
            'TramosRentabilidad',
            ( [Rentabilidad] * 100 ) >= 'TramosRentabilidad'[fValMinTramo]
                && ( [Rentabilidad] * 100 ) < 'TramosRentabilidad'[fValMaxTramo]
        )
    )
)

Regards,