topic Re: Need a DAX Measure in DAX Commands and Tips

Need a DAX Measure

Prakash1050 — Fri, 30 Jun 2023 06:04:11 GMT

Hi All,

I have three table A and table B, table C.

Table A have ID, Value, EntityID columns.

Table B have EntityID, SI.No columns.

Table C have SI.No, Grade Columns.

Table A, Table B have Same EntityID column and Table B, Table C have same SI.No column.

I need a DAX Measure for Calculate Average Weight by Using Table A "Value" Column. Like Table A "Value" 's each row should be divided by That column "Grand Total" and get each row values are multiplied by Table B "SI.No" then Roundup the values and compare to the Table C "SI.No" column and get the "Grade" Column.

If i filter Table A "EntityID" means i get also filtered "Grade" Column in Table C.

I don't want to create relationships these tables.

Please help me.

Thanks i Advance

Re: Need a DAX Measure

Anonymous — Mon, 03 Jul 2023 07:20:35 GMT

Hi Prakash1050 ,

I think your calculation is based on your data model. According to your statement, I am still confused on some parts. Please share a sample file with us and show us a screenshot with the calculation logic and the result you want. This will make it easier for us to find the solution.

Best Regards,
Rico Zhou

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Re: Need a DAX Measure

Jesu_Jeevian — Mon, 03 Jul 2023 07:49:32 GMT

Declare Variable for Entity ID with the combination of Sl No columns and do your calculations in the return statement. Meanwhile make the relationships between these tables, or create a bridge table