Need Dax Measure

Question

Hi All,&nbsp; &nbsp; &nbsp; &nbsp;I need DAX Measure for below the Scenario.&nbsp;I have one Column.&nbsp;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;Values&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;100&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;200&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;300&nbsp;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;What i need is This Column total is 600. I need all the row divided by the total. Ex : 100/600 = 0.17 , 200/600 = 0.34 like that.&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; I used this measure ( DAX =&nbsp;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; var value = calculate(sum(Values))&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; var allValue = calculate(sum(Values) , Allselected(Values))&nbsp;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;Return value/allValue&nbsp; )&nbsp;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;But this measure is not working correctly.&nbsp;&nbsp;Please help me to done this logic.Thanks in Advance.

mlsx4 · Answer

Hi&nbsp;Prakash1050&nbsp;&nbsp;I would use two measures:Total sum= SUM(Values)And then,% of value =

var allValues= CALCULATE([Total sum],ALL(Table))
return DIVIDE([Total sum],allValues,0)

prakash1050 · Answer

Hi&nbsp;mlsx4 ,&nbsp;&nbsp; &nbsp; &nbsp; Thanks for your reply.&nbsp; &nbsp; &nbsp; This measure works correct. If i have id column as well.Ex :&nbsp;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;ID&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;Value&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 1&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;100&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 2&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;200&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 3&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;200&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 1&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;400&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 1&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;100&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 2&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 200&nbsp;Above the table ID in filters, if i select ID 1 means only 3 ID, Values rows are coming and the above measure is not suitable for this scenario.So, kindly done this logic.&nbsp;&nbsp;

mlsx4 · Answer

Hi&nbsp;Prakash1050&nbsp;&nbsp;Not really understand the point. Can you put an example of what you do and what you expect to get?

prakash1050 · Answer

Sure, forgot the 1st reply message.&nbsp;I need to show the total in all the rows. Kindly reply the measure

Forum Discussion

Need Dax Measure

4 Replies

Related content

DAX Measure

POWER BI DAX MEASURE

Dax measure help

Help to create DAX Measure

DAX Calculated Measure