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.

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