Is there a way in Power BI to show the sum of multiple columns randomly

1
votes

I have three columns value in my Power BI report let's just name them column1, column2, column3 I'm wondering if there is a visualization in Power BI that can show their sum value randomly For example, in this visualization, I can either select to show the sum value of column1+column2+column3 all toghther or show two of them like column1 + column3, column2+ column3, and column1+column2 etc. or just single column's value I hope there is a selector in the visualization that I can select the columns' value I want to show as sum

Is there a way in Power BI to do that?

1
powerbidata-visualization

1 Answers

1
votes

You can use the RANDBETWEEN function to randomly choose whether or not to include a column (0 or 1).

Rand = [Column1] * RANDBETWEEN(0,1) +
       [Column2] * RANDBETWEEN(0,1) +
       [Column3] * RANDBETWEEN(0,1)

Note that this does have the possibility of summing none of the three.