Else condition is not working

Question

Hi Everyone,&nbsp;Below is my dax expression .&nbsp; I need to format the values based on responsetype column.&nbsp; If responsetype is percentage (ex:###,###,###,##0%) then I should divide value by 100 else values. Please help&nbsp;Responsetype:###,###,###,##0###,###,###,##0%###,###,###,##0.0%###,###,###,##0.0$###,###,###,##0&nbsp;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 · Answer

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&nbsp;&nbsp;
Regards,
Xiaoxin Sheng

Forum Discussion

Else condition is not working

1 Reply

Related content

if else condition

SWITCH condition with ELSE conditional

if else condition in dax

If, Or, Else not working

Translate IF, ELSE IF, ELSE in DAX langage