Issue with creating a measure

[Bandi]

Hi everyone,

I'm in the middle of the process of creating my very first application in  QS. 2 days ago I have stuck when I wanted to create a new measure.

My whole first dashboard base on one measure, which looks like this:

Num(Count({<Resposta={TAK}>} [Store])/ Count ({<Resposta-={'N/A'}>} [Store]), '#0,0%')

For the second dashboard I was trying to calculate somethink like "Calculated measure" 

For one of my dimensions which includes only 2 fields  "Operation1" and "Operation2"  I need to calculate the difference between them. 

For example: the attached measure would give as a result 90% for Operation1 and 70% for Operation2 and I would like to see the final outcome 20% (Operation1 - Operation2) 

I have tried to accomplish it with this IF measure but it didn't work.

if([Function]='Operation1',Num(Count({<Resposta={TAK}>} [Store])/ Count ({<Resposta-={'N/A'}>} [Store]), '#0,0%'))
- (if([Function]='Operation2',Num(Count({<Resposta={TAK}>} [Store])/ Count ({<Resposta-={'N/A'}>} [Store]), '#0,0%')))

I will be really greatful for any help 🙂 

[joaopaulo_delco · Accepted solution]

Hi @Bandi !

           Try this way:

Num((Count({<Resposta={'TAK'},Function={'Operation1'}>} [Store])
/ Count({<Resposta-={'N/A'}, Function={'Operation1'}>} [Store])
)
-
(Count({<Resposta={TAK},Function={'Operation2'}>} [Store])
/
Count({<Resposta-={'N/A'},Function={'Operation2'}>} [Store])) , '#0,0%')

[Ksrinivasan]

hi,

try this

=(if([Function]='Operation1',

(Num(Count({<Resposta={TAK}>} [Store]))/ (Count ({<Resposta-={'N/A'}>} [Store])), '#0,0%')) - 

(if([Function]='Operation2',

(Num(Count({<Resposta={TAK}>} [Store]))/ (Count ({<Resposta-={'N/A'}>} [Store])), '#0,0%'))

ksrinivasan