Forum Discussion

cosminc's avatar
cosminc
Post Partisan
7 years ago
Solved

DAX KPI dynamic format % or number

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
Need Help

3 Replies

    • cosminc's avatar
      cosminc
      Post Partisan
      7 years ago

      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's avatar
        v-piga-msft
        Resident Rockstar
        7 years ago

        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