Forum Discussion

barlevitzky's avatar
barlevitzky
Helper I
8 years ago
Solved

Create a complicated measure

Hi all, I have the following table: Date  Browser  Cost  Test 26.10 CH            5       A 26.10 FF             10     A 26.10 CH            10     B 26.10 FF             10     B   I want t...
Need Help
  • Ashish_Mathur's avatar
    Ashish_Mathur
    8 years ago

    Hi barlevitzky,

     

    You are missing the second input in the ALLEXCEPT function.  The first is the table which you have given.  The second input should be the column.

Anonymous's avatar
Anonymous
Not applicable
8 years ago

barlevitzky,

Please post the DAX you use, as the error message mentioned, you pass two few arguments to ALLEXCEPT function.



Regards,
Lydia

barlevitzky's avatar
barlevitzky
Helper I
8 years ago

Hi Anonymous,

Thank you for your help!

 

this is the DAX i wrote:

  • Ashish_Mathur's avatar
    Ashish_Mathur
    Super User
    8 years ago

    Hi barlevitzky,

     

    You are missing the second input in the ALLEXCEPT function.  The first is the table which you have given.  The second input should be the column.

  • barlevitzky's avatar
    barlevitzky
    Helper I
    8 years ago

    Hi Ashish_Mathur,

    "Revenue per partner" is the table name and "test" is the column name. 

  • Ashish_Mathur's avatar
    Ashish_Mathur
    Super User
    8 years ago

    Hi,

     

    So it should be:

     

    ALLEXCEPT('Revenue per partner','Revenue per partner'[test])

  • barlevitzky's avatar
    barlevitzky
    Helper I
    8 years ago

    Sorry, the same error message is still on. 

  • Ashish_Mathur's avatar
    Ashish_Mathur
    Super User
    8 years ago

    Hi,

     

    Considering Lydia wrote the formula for you initially (which was even marked as Answer), it would be best if she helps you with this.  For me to help, you I'd have to request you to explain me the entire question (which will waste your time).