Calculation

[Srinivas3350]

I am having these columns can anyone help me in DAX that needs to calculate value for Ink and solvent sepratley so the table sholud look like in columns years and in rows INk & Solvent and values the GBP i dont need those ink & solvent litres

Thanks 

Srinivas

[Anonymous · Accepted solution]

Hi @Srinivas3350 ,

We can create measures.

Ink GBP Value = 
SUMX(
    FILTER('Table', 'Table'[fin_year] = MAX('Table'[fin_year])),
   'Table'[ink_litres]*'Table'[GBP_Value]
)

Solvent GBP Value = 
SUMX(
    FILTER('Table', 'Table'[fin_year] = MAX('Table'[fin_year])),
    'Table'[solvent_lires]*'Table'[GBP_Value]
)

If the above one can't help you get the desired result, please provide some sample data in your tables (exclude sensitive data) with Text format and your expected result with backend logic and special examples. It is better if you can share a simplified pbix file. Thank you.

Best Regards,

Neeko Tang

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

[Anonymous · Accepted solution]

Hi @Srinivas3350 ,

We can create measures.

Ink GBP Value = 
SUMX(
    FILTER('Table', 'Table'[fin_year] = MAX('Table'[fin_year])),
   'Table'[ink_litres]*'Table'[GBP_Value]
)

Solvent GBP Value = 
SUMX(
    FILTER('Table', 'Table'[fin_year] = MAX('Table'[fin_year])),
    'Table'[solvent_lires]*'Table'[GBP_Value]
)

If the above one can't help you get the desired result, please provide some sample data in your tables (exclude sensitive data) with Text format and your expected result with backend logic and special examples. It is better if you can share a simplified pbix file. Thank you.

Best Regards,

Neeko Tang

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

[Srinivas3350]

when I am doing * it is showing large value. if in a row i am having 5L of ink and Solvent that is the GBP Value for both in that row if i am multiplying it is showing huge value. let me give you an example

ink- 5L & Sol 5L GBP for both is 100 its is calculating 10*100 = 1000

[Anonymous · Accepted solution]

Hi @Srinivas3350 ,

We can create measures.

Total Litres = 
SUM(YourTableName[ink_litres]) + SUM(YourTableName[solvent_litres])

Ink GBP Value = 
SUM(YourTableName[ink_litres]) / [Total Litres] * SUM(YourTableName[GBP_Value])

Solvent GBP Value = 
SUM(YourTableName[solvent_litres]) / [Total Litres] * SUM(YourTableName[GBP_Value])

If the above one can't help you get the desired result, please provide some sample data in your tables (exclude sensitive data) with Text format and your expected result with backend logic and special examples. It is better if you can share a simplified pbix file. Thank you.

Best Regards,

Neeko Tang

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

[Srinivas3350]

This is working thank you

[Srinivas3350]

I think I need your help how to share a file in this chat