Divide rows by a measure

[souvik900766]

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?

[amitchandak]

@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")))

[amitchandak]

@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"))

[souvik900766]

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

Thanks in Advance !

[amitchandak]

@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")))