topic Re: Get sum of amount base on third table flag in DAX Commands and Tips

Get sum of amount base on third table flag

Mniknejad — Wed, 18 Dec 2019 22:06:13 GMT

I have 3 table's first table is

second table is a dim

and third table is a staing table which has related to dim table

now I wanted to claculate a measure which shows sales amount for salesorderId with "IsActiveFlag" equal "1"

Can any body know how cani do this ? what would be the "DAX" code for this

Anonymous — Thu, 19 Dec 2019 05:15:59 GMT

Mniknejad try below measure

Measure = CALCULATE(SUM(Table1[SalesAmount]),Table3[IsActiveFlag]=1)

Anonymous — Thu, 06 Aug 2020 04:36:38 GMT

First connect these 3 tables as the staing table with dim table on sales order ID and sales dim key with sales dim key (1st & 2nd table)

Post this, write a measure calculate(sales),activeid =1)

If this works, please mark this as solution.