Forum Discussion

Bi2thelly's avatar
Bi2thelly
Helper II
4 years ago
Solved

Invalid input arguments for ISSELECTEDMEASURE.

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 

Need Help
  • Bi2thelly's avatar
    Bi2thelly
    4 years ago

    Yes, 

    Invalid input arguments for ISSELECTEDMEASURE.

     

3 Replies

    • Bi2thelly's avatar
      Bi2thelly
      Helper II
      4 years ago

      Yes, 

      Invalid input arguments for ISSELECTEDMEASURE.

       

      • bcdobbs's avatar
        bcdobbs
        Community Champion
        4 years ago

        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...