Need a DAX Measure

[Prakash1050]

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

[Jesu_Jeevian]

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 

[v-rzhou-msft]

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.