topic Re: Multiple answers and using other in DAX Commands and Tips

Multiple answers and using other

Hjameelaq — Wed, 06 Nov 2024 17:26:25 GMT

Hello all,

I have a multiple answer question and I want to make a bar visual which is something I know how to do. What I want is to show only options that have 3% higher and show other option instead of these options that are below 3% and show a small hint underneath thus bar saying other options include 1, 3 blah blah... can you please help!

Regards, Hanna

Re: Multiple answers and using other

FreemanZ — Wed, 06 Nov 2024 18:30:04 GMT

hi Hjameelaq ,

supposing you have two columns: answer and percentage, try to plot the barchart with two calculated columns:

answer2 =

IF([percentage]>=0.03, [answer], "Others")

Percentage2 =

IF(

[answer]=[answer2],

[percentage],

SUMX(

FILTER(data, data[answer2]="Others"),

data(percentage)

)

Re: Multiple answers and using other

Hjameelaq — Wed, 06 Nov 2024 19:30:53 GMT

I will give this a try, how can we show these options on table like saying

Others is blah blah blah...

Re: Multiple answers and using other

Hjameelaq — Thu, 07 Nov 2024 09:02:03 GMT

How do we calculate the sum of all values for a column to be able to calcuate the % for each ?

Re: Multiple answers and using other

FreemanZ — Thu, 07 Nov 2024 09:55:55 GMT

hi Hjameelaq ,

try to write a calculated column like:

Column =

DIVIDE(

data[value],

SUM(data[value])

)