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

Anonymous's avatar
Anonymous
Not applicable
10 years ago

Thanks for your reply MattAllington

 

can you please tell how we gonna differentiate 

 

1. New Column           (Reoprt view) where we use new column instead of new measure

2. New Measure          (Report view) where we use new measure instead of new column

 

Actually I have experience with 'New Measures' which are giving me good results but I didn't go for 'New Column' in my reports yet, because I started Power BI a month ago.

It is ok even if u want me to refer a blog, but please help me out with this.

 

Thanks in advance.