Hello,
I've been googling a lot before to post this question but I have not been able to find any answer.
I have a table named "TABLE" (say) and I defined a measure in it named "MEASURE".
Now, in another worksheet I can use a formula like this:
=SUMIFS(TABLE[Amount];TABLE[ID];10), where of course Amount and ID are fields of the table.
No issue with such a formula. But I need another formula like this:
=SUMIFS(TABLE[MEASURE];TABLE[ID];10)
which is not accepted, as measures are not even listed in the field list which is shown by typing the formula.
What am I missing and I could I retrieve the value of MEASURE under given conditions?
Thanks in advance
I've been googling a lot before to post this question but I have not been able to find any answer.
I have a table named "TABLE" (say) and I defined a measure in it named "MEASURE".
Now, in another worksheet I can use a formula like this:
=SUMIFS(TABLE[Amount];TABLE[ID];10), where of course Amount and ID are fields of the table.
No issue with such a formula. But I need another formula like this:
=SUMIFS(TABLE[MEASURE];TABLE[ID];10)
which is not accepted, as measures are not even listed in the field list which is shown by typing the formula.
What am I missing and I could I retrieve the value of MEASURE under given conditions?
Thanks in advance
