Help! send measure using REST API

ToniMuñoz — Thu, 08 Nov 2018 18:08:47 GMT

Hello!

I have created Dataset (using rest api) with simple measure and code is ok.

Like this :

'measures': [

{

'name': 'Totales',

'expression': 'sum(Data[Pendientes])',

'formatString': '0'

}

]

But when i use filters

'measures': [

{

'name': 'Totales',

'expression': 'calculate(MAX(Data[Pendientes]),FILTER(Data,Data[TIPO]="T")))',

'formatString': '0'

}

]

I have a problem with quotation marks, i try with simple, double, but now i cant create dataset... if i remove the expression for simple its ok.

Can u help me?

Sorry @ my english!

Re: Help! send measure using REST API

ToniMuñoz — Thu, 08 Nov 2018 19:40:09 GMT

Solved with this Measure

'measures': [

{

'name': 'Totales2',

'expression': 'calculate(sum(Data[Pendientes]),filter(Data,Data[ID]=MAX(Data[ID]) && Data[TIPO]=""T""))',

'formatString': '0'

}

]

My problem was not in quote marks i thik that measure was not correct.