Forum Discussion
Table values are getting repeated
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
Hi MattAllington.
A . Can u please tell what is the difference between
1. 'Add Custom Column' (at Edit Queries > Add Custom Column)
&
2. 'New Column' (Power BI Desktop Report view)
B. What language does this 1 uses? we are unable to use any aggregation function like 'SUM' etc.. neither we can use 'Calculate' function which is a part of DAX.
can you please elaborate about these two whenever you feel free..!!
I have gone through this artice in which i can clearly say whatis the difference between 'Calulated Column' and 'Calculated Measure', but I am unable get difference between 1 and 2(talked earlier).
Thanks in advance.
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.
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.
I always refer to my blog for this question. http://exceleratorbi.com.au/calculated-columns-vs-measures-dax/
generally it is ok to create new columns as long as you know "why" you are doing it over a measure. Also, better to push the column work back to power query or to the source.