cancel
Showing results for
Did you mean:
Highlighted ## Multiple calculations in DAX

Hello All ,

I have a scenario ;

Table A:

 ID WEIGHT Investment Option value 1 0.2 Stocks 1 1 1.2 Accounts 1 2 2.2 Stocks 1 2 3.2 Accounts 1 2 4.2 PPF 0 3 5.2 Stocks 1

Table B: Table B consist of Max Weight group by Id.

 id Weight 1 1.2 2 4.2 3 5.2

If I select options Stocks , Accounts .

SQL 1. : Select Sum(weight) from table B where ID in (select distinct ID from Table A where Value =1  and Investment Option = 'Stocks , Accounts')

***Investment option would be drived from slicer

SQL 2 : Select Sum(Weight) from table B

measure = SQL1 Result / SQL 2 result

How would this measure can be achived through DAX .

Regards ,

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted

## Re: Multiple calculations in DAX

Your post is a little confusing, but let me try

Join the tables on the ID column

write these measure.

Sql 1 = calculate(sum(tableA[weight],tableA[value]=1)

sql 2 = sum(tableB[weight])

measure = divide([sql 1],[sql 2])

* Matt is a Microsoft MVP (Power BI) and author of the Power BI Book Supercharge Power BI.
2 REPLIES 2
Highlighted

## Re: Multiple calculations in DAX

Your post is a little confusing, but let me try

Join the tables on the ID column

write these measure.

Sql 1 = calculate(sum(tableA[weight],tableA[value]=1)

sql 2 = sum(tableB[weight])

measure = divide([sql 1],[sql 2])

* Matt is a Microsoft MVP (Power BI) and author of the Power BI Book Supercharge Power BI.
Highlighted ## Re: Multiple calculations in DAX

Hello @MattAllington ,

Thanks that worked with little tweak as below :

As I wanted max , I took the values from table B and rest other are the same .

Sql 1 = calculate(sum(tableB[weight],tableA[value]=1)

Announcements #### Power Platform Community Conference

Check out the on demand sessions that are available now! #### Experience what’s next for Power BI

See the latest Power BI innovations, updates, and demos from the Microsoft Business Applications Launch Event. #### Power Platform 2020 release wave 2 plan

Features releasing from October 2020 through March 2021 #### Get Ready for Power BI Dev Camp 