Else condition is not working

[Kavya123]

Hi Everyone,

Below is my dax expression .  I need to format the values based on responsetype column.  If responsetype is percentage (ex:###,###,###,##0%) then I should divide value by 100 else values. Please help 

Responsetype:

###,###,###,##0

###,###,###,##0%

###,###,###,##0.0%

###,###,###,##0.0

$###,###,###,##0

if(HASONEVALUE(Merge1[ResponseType]), FORMAT( CALCULATE(SUM(Merge1[Value]) , FILTER(Merge1, Merge1[Benchmark (2).iIdConsortium]=52)), "###,###,###,##0

"), FORMAT( DIVIDE( CALCULATE(SUM(Merge1[Value]) , FILTER(Merge1, Merge1[Benchmark (2).iIdConsortium]=52)), 100), "###,###,###,##0.0%"))

[Anonymous]

Hi @Kavya123,

Can please share some dummy data with a similar data structure and expected results? It should help us clarify your scenario and test to coding formula.

How to Get Your Question Answered Quickly  

Regards,

Xiaoxin Sheng