topic Re: Divide rows by a measure in DAX Commands and Tips

Divide rows by a measure

souvik900766 — Thu, 14 Jan 2021 15:01:53 GMT

Hi !

I have a measure:-

Base for Volume Share within Category = CALCULATE([Volume CY],Table[company_nm]="Full Industry")
Now, with this measure I want to divide every row (i.e my products value) to get the share within the industry.
But I am getting blank rows !
How to calculate this?

Re: Divide rows by a measure

amitchandak — Thu, 14 Jan 2021 15:16:35 GMT

souvik900766 , I so how not clear with your formula.

It shoulw be like this if you need % of total

divide([Volume CY], calculate([Volume CY], allselected(Table)))

or // I am not sure on this one, but seem like this name is not there in selection

Category = CALCULATE([Volume CY],Filter(all(Table[company_nm]),Table[company_nm]="Full Industry"))

Re: Divide rows by a measure

souvik900766 — Thu, 14 Jan 2021 16:44:16 GMT

Hi !
It is not working. I think thr is a lack of clarity from my side.
Kindly Check this !

Thanks in Advance !

Re: Divide rows by a measure

amitchandak — Thu, 14 Jan 2021 17:12:17 GMT

souvik900766 , one of the three measure. Assume [Volume] is a measure

Category = divide([Volume],CALCULATE([Volume],Filter(allselected(Table),Table[company_nm]="Full Industry")))

Category = divide([Volume],CALCULATE([Volume],Filter(all(Table[company_nm]),Table[company_nm]="Full Industry")))

Category = divide([Volume],CALCULATE([Volume],Filter(allselected(Table[company_nm]),Table[company_nm]="Full Industry")))

Re: Divide rows by a measure

amitchandak — Fri, 15 Jan 2021 04:30:31 GMT

souvik900766 ,

one of the three measure. Assume [Volume] is a measure

Category = divide([Volume],CALCULATE([Volume],Filter(allselected(Table),Table[company_nm]="Full Industry")))

Category = divide([Volume],CALCULATE([Volume],Filter(all(Table[company_nm]),Table[company_nm]="Full Industry")))

Category = divide([Volume],CALCULATE([Volume],Filter(allselected(Table[company_nm]),Table[company_nm]="Full Industry")))