Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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
Solved! Go to 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]))
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] ) )
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] ) )
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.
User | Count |
---|---|
54 | |
23 | |
19 | |
18 | |
17 |
User | Count |
---|---|
91 | |
86 | |
46 | |
28 | |
22 |