DAX KPI dynamic format % or number

[cosminc]

Hi

i use a measure like this

KPI =

VAR _value =

SELECTEDVALUE ( 'KPI'[KPI] )

VAR result =

[sum]

* IF ( _value = "Budget", 1, 0 )

+ [share]

* IF ( _value = "Share", 1, 0 )

RETURN

result

the measure is formated as number with 1 decimal, but when _value is "Share" i need to be seen as %

thanks,

Cosmin

[ChrisMendoza · Accepted solution]

@cosminc -

Maybe https://www.sqlbi.com/articles/using-concatenatex-in-measures/ might help in your situation? If you posted sample data, I am sure you will receive more assistance as it isn't clear what the data looks like.

[cosminc]

Thanks Chriss,

the column measure is formatted as number

and there are 2 posibilities, but one of them i want to represent as %

so in the same time the measure i want to be number  or when i switch to the other result need to be %

concatenate uses only text data?

i'm trying to use this.

thanks,

Cosmin

[v-piga-msft]

Hi @cosminc ,

Have you solved your problem?

If you have solved, please always accept the replies making sense as solution to your question so that people who may have the same question can get the solution directly.

If you still need help, please share some data sample and your desired output so that we could help further on it.

Best Regards,

Cherry