Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now! Learn more
I'm using Tabular Editor in Power Bi and I keep running into an error when using multiple arguements in the function ISSELECTEDMEASURE. I can't seem to find out what is wrong with this calculation.
IF ( ISSELECTEDMEASURE ( [Expt_Forecast Tickect AVG], [Expt_Forecast Tickect High], [Expt_Forecast Tickect Low], [Expt_Actuals] ), SELECTEDVALUE ( 'dTrendCodes'[Trend Level 1] ) )
Looking at the Microsoft Documentation it appears that you can use more than one measure in this function. So I cannot see what is wrong.
ISSELECTEDMEASURE( M1, M2, ... ) ISSELECTEDMEASURE function (DAX) - DAX | Microsoft Docs
Solved! Go to Solution.
Yes,
Can't see anything obviously wrong.
Have you double checked measure spelling/white spaces.
You could see if you can narrow down the problem by removing one measure at a time or writing something like:
ISSELECTEDMEASURE ( [M1] ) ||
ISSELECTEDMEASURE ( [M2] ) ||
etc...
The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now!
| User | Count |
|---|---|
| 61 | |
| 46 | |
| 40 | |
| 38 | |
| 22 |
| User | Count |
|---|---|
| 176 | |
| 131 | |
| 118 | |
| 82 | |
| 54 |