Forum Discussion
How to return either a single text variable or multiple text variable with the IF function in DAX
Hi, Can anyone help me with this, I am trying to return either a single text variable or multiple text variable within an IF function in DAX. This would be based on a variable IsManager = 1 will retu...
Sure. Basically, If the user has lets say the node .2521.3456.1885. as his department then he should only see that department in the reports. If the user is also a Manager then they should see all the departments starting from that node. Hence example below. The Nodes are text. If you are interested I could put up some cleansed cut back version in pbix.
| .2521.3456.1855. |
| .2521.3456.1855.1643. |
| .2521.3456.1855.1643.1976. |
| .2521.3456.1855.1643.2081. |
| .2521.3456.1855.1643.2226. |
etc...
