Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and a 50 percent discount on exams.
Get startedEarn 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.