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

Theres are 2 distinct and different technologies rolled into Power BI

1 is Power Query.  It uses a language officially called Power Query Formula Language, developed from "M". I call it PQL (like SQL). Power Query is an ETL tool used to shape data before loading to Power Pivot

 

2 is power pivot. It is a reporting data base that uses DAX as a language. SUM is an example

 

you question makes me think is is a good blog post topic. I will post back here once it is done. 

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.