Cannot find table name

[ramhariessentia]

Hi all again a dump question from my side, I am trying to create a measure & i see that certain functions such as sum i am able to see all tables available howver if i you conditional statements I am only able to see quick measure tables only

Eg

Total=SWITCH(True(),Transactions[Fee name ID]

This can be seen in the dropdown when I use sum function & doesnt give syntax error either.

[v-robertq-msft · Accepted solution]

Hi, @ramhariessentia 

According to your description, I think this is because of the difference between the two DAX functions.

When you used Sum() function, you can place any column or measure in it, and the result of this expression can calculate the sum of it.

When you used the Switch() function, if you used the True() as the first parameter, the value of the second parameter should be a true/false type.

As a result, the DAX expression should be like this:

Total=SWITCH(True(),Transactions[Fee name ID]=1,result,other result)

More info about the Switch() function

More info about the Sum() function

Thank you very much!

If this result is not what you want, you can post some sample data(without sensitive data) and your expected result.

How to Get Your Question Answered Quickly 

Best Regards,

Community Support Team _Robert Qin

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.