formatting in a single measure column (% and Integer)

[Pilot]

Hi All,

Wondering if you can assist with 2 questions....

1. We have dual formatting in a single measure column (% and Integer) that we would like to utilize in a graph, is there a way to show a percent and integer depending on the single measure selected? Is there a way to do this in DAX?
   
   
2. Is there a way to calculate the variance between 2 measure that will show the difference  between two item in a single table – dynamically (instead of showing the sum we need to show the variance) based on a single measure column….

Appreciate your support....

Regards

Chris

[Eric_Zhang]

@Pilot

For the first question, can you try to use an IF? Some expression like

IF(yourMeasure>1,yourMeasure,CONCATENATE(yourMeasure,"%"))

Regarding the second question, it is not quite clear for me, can you be more specific? Better with sample data and expected output. Thanks.

[Pilot]

@Eric_Zhang

Thanks for the response, as for the second questions

We have two measures that we wanted to use but they are both on a single measure column and wanted to calculate and show the variance between the two measures. If this makes sense?

Thanks

Pilot

[Baskar]

Hi Pilot

1. If(Yourmeasure=your condition,Yourmeasure,YourMeasure & "@" , & " %" ) -- Whatever and howmuch  you want add

2. It's make sense . Use like Table1[Measure] + Table2[Measure],
If u dont want in DAX, U can go with data modelling. Eg. Merge Two table .