Forum Discussion
Cannot find table name
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
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.
1 Reply
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.