Forum Discussion
Table values are getting repeated
Hello, I got 4 columns in my 'Table' all of them are custom columns created using query editor 1. Gross Sales 2. COGS 3. Gross Margin (Gross Sales - COGS) 4. Gross Margin % (Gross M...
You should write a measure that produces the 300 regardless of the value in the rows
denominator =calculate(sum(table[gross sales]),all(table[cus]))
then write a measure
=sum(table[gross sales])/denominator
You should write a measure that produces the 300 regardless of the value in the rows
denominator =calculate(sum(table[gross sales]),all(table[cus]))
then write a measure
=sum(table[gross sales])/denominator
hey MattAllington
i tried ur way but its giving me only 1.00 value in every row...