DAX Measure help

[abhiram342]

Hi All,

I want to create measure for below scenario. I have FactTable and 3 dimension Tables as you see in screenshot.

scenario: I want to show data only for AnchorCustomers combination.

SalesAmount: = sum('Sales'[Amount])

Relationships:

Thanks,

Abhiram

[abhiram342 · Accepted solution]

Thanks @wdx223_Daniel ! Is there way that I can re-use measure. Example If I want to get Total Sales then I need to create new measue. I need to repeat totalsalesanchorfor mom,yoy,ytd. Can you please tell how can I use the same measure

TotalSales =  Sum([SalesAmount])

TotalSalesAnchor=IF(MAX(AnchorCustomer[IsAnchor]),SUM[SalesAmount]))

[tamerj1 · Accepted solution]

Hi @abhiram342 
You can use visual level filter pane. Place the following measure in the filter pane, select "is" and type 1 then apply the filter.

FilterMeasure =
INT ( MAX ( AnchorCustomer[IsAnchor] ) )

[wdx223_Daniel]

AnchorSales=IF(MAX(AnchorCustomer[IsAnchor]),SUM[SalesAmount]))

[abhiram342 · Accepted solution]

Thanks @wdx223_Daniel ! Is there way that I can re-use measure. Example If I want to get Total Sales then I need to create new measue. I need to repeat totalsalesanchorfor mom,yoy,ytd. Can you please tell how can I use the same measure

TotalSales =  Sum([SalesAmount])

TotalSalesAnchor=IF(MAX(AnchorCustomer[IsAnchor]),SUM[SalesAmount]))

[wdx223_Daniel]

calculation group can do that job.