Forum Discussion

jct999's avatar
jct999
Icon for Advocate II rankAdvocate II
6 years ago

DAX :

Hi,   I have a table with 3 columns : COUNTRY (string) LEVEL (integer) Quantity (integer) I want to set up a Pivot Table with : Line : COUNTRY Column : LEVEL Values : 3 measures : Measur...
lbendlin's avatar
lbendlin
Icon for Super User rankSuper User
6 years ago

Measure 2 = 

var L=selectedvalue(table[Level])

return calculate(sum(Table[quantity]),table[Level]=L+1)