Forum Discussion

barlevitzky's avatar
barlevitzky
Icon for Helper I rankHelper 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.

barlevitzky's avatar
barlevitzky
Icon for Helper I rankHelper I
8 years ago

Hi, Anonymous

 

I got an error message: "Too few arguments were passed to ALL EXCEPT function. The minimum argument count for the function is 2. " 

 

I don't get it. I have in each Variant more than 2 rows. 

 

Thanks.  

 

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

  • Ashish_Mathur's avatar
    Ashish_Mathur
    Icon for Super User rankSuper 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
    Icon for Helper I rankHelper I
    8 years ago

    Hi Anonymous,

    Thank you for your help!

     

    this is the DAX i wrote:

  • barlevitzky's avatar
    barlevitzky
    Icon for Helper I rankHelper 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
    Icon for Super User rankSuper User
    8 years ago

    Hi,

     

    So it should be:

     

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

  • barlevitzky's avatar
    barlevitzky
    Icon for Helper I rankHelper I
    8 years ago

    Sorry, the same error message is still on. 

  • Ashish_Mathur's avatar
    Ashish_Mathur
    Icon for Super User rankSuper 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).