Forum Discussion
DAX Measure help
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
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]))
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] ) )
4 Replies
AnchorSales=IF(MAX(AnchorCustomer[IsAnchor]),SUM[SalesAmount]))
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]))
calculation group can do that job.
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] ) )
