Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
10 years ago
Solved

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...
Need Help
  • MattAllington's avatar
    MattAllington
    10 years ago

    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

MattAllington's avatar
MattAllington
Community Champion
10 years ago

There is an inbuilt DIVIDE function that handles divide by zero errors. 

 

=DIVIDE(numerator,denominator)

Anonymous's avatar
Anonymous
Not applicable
10 years ago

Thank u.

Can u please help me out with this too..?

Gross Sales is there and i wanna do following calculation 

Cus   Gross sales   new_column(Gross Sales / Total Gross Sales)

  1       100                100/300

  2       200                200/300

Total   300    

 

How um i suppose to use total of gross sales column in measure calculation..??