Forum Discussion
Create a complicated measure
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.
How do you get 12 for partner B under Variant C? You also have Variant B. Based on your sample data, I creating the following measures and get the following result.
Total C = CALCULATE(SUM(Table[Revenue]),ALLEXCEPT(Table,Table[Test]),Table[Test]="Variant C")
Total D = CALCULATE(SUM(Table[Revenue]),ALLEXCEPT(Table,Table[Test]),Table[Test]="Variant D")
TOTAL D/C = [Total D]/[Total C]
Regards,
Lydia
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.
barlevitzky,
Please post the DAX you use, as the error message mentioned, you pass two few arguments to ALLEXCEPT function.
Regards,
LydiaHi Anonymous,
Thank you for your help!
this is the DAX i wrote:
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,
Please check the DAX I use in this PBIX file, if you still get error message, please share me your PBIX file.
Regards,
LydiaAnonymous
I Click on download and nothing happen.
Can you please send it to my email?
Thanks
barlevitzky,
I send the PBIX file to you via Email.
Regards,
Lydia