Create a measure that returns multiple columns

Question

Guys, I have a problem. I created a selection menu with the following conditions:measure_test = SWITCH(TRUE();&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;SELECTEDVALUE(menu[option]) = "1";&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;SUM(table[INSCRITOS]);&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;SELECTEDVALUE(menu[option]) = "2";&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;SUM(table[INSCRICOESCOMPLETAS]); SELECTEDVALUE(menu[option]) = "3";&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;SUM(table[PAGARAMINSCRICAO]);SELECTEDVALUE(menu[option]) = "4";&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;SUM(table[AVALIADOS]);SELECTEDVALUE(menu[option]) = "5";&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;SUM(table[CONVOCADOS]);&nbsp;SELECTCOLUMNS(table;"a";SUM(table[CONVOCADOS]);"b";SUM(table[AVALIADOS])))But, if no option is selected, I want to show the all results.&nbsp;What would a measure look like that would show all other measures?When selection one:&nbsp;When nothing is selected,&nbsp;need to show everyone:&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;

parry2k · Answer

AyaneYep&nbsp;it is not very clear what you are trying to achieve. Can you provide some data/screen shot and expected output.&nbsp;Read this post to get your answer quickly. https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490

v-yuta-msft · Answer

AyaneYep&nbsp;,
&nbsp;
Could please share some sample data and give the expected result?
&nbsp;
Regards,
Jimmy Tao

anonymous · Answer

HI, maybe try like thisIF (&nbsp;&nbsp;&nbsp; AND (&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; NOT ( SELECTEDVALUE ( table[MENU] ) );&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; NOT ( SELECTEDVALUE ( table[MENU_ITERATIVO] ) )&nbsp;&nbsp;&nbsp; );&nbsp;&nbsp;&nbsp; SUM ( table[A] ) + SUM ( table[B] )&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; + SUM ( table[C] )

ayaneyep · Answer

In fact, I need to show all the results, not add up.

anonymous · Answer

Here is a link with my solution ( of course if i understood well)
https://sharefiles.app/download/c3e5f3a04c8b4c1ade63ebfb3c3c78bfb73e7664 or here https://secufiles.com/aCnC/scr.png
Sorry cant upload photos. it doesnt work today.
Your are using function "selectcolumns" in your measure. im not sure that is appropriate for a measure as this function is used to create tables

Forum Discussion

Create a measure that returns multiple columns

6 Replies

Related content

Measure returning incorrect value

Measure to return multiple values

Measure and return multiple columns

Measure is returning BLANK

DAX Measure Returning Incorrect Results