Forum Discussion

abhiram342's avatar
abhiram342
Icon for Microsoft Employee rankMicrosoft Employee
3 years ago
Solved

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.   SalesA...
"DAX"
"Need Help"
USERELATIONSHIP
  • abhiram342's avatar
    abhiram342
    3 years ago

    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's avatar
    tamerj1
    3 years ago

    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's avatar
wdx223_Daniel
Icon for Community Champion rankCommunity Champion
3 years ago

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

abhiram342's avatar
abhiram342
Icon for Microsoft Employee rankMicrosoft Employee
3 years ago

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's avatar
    wdx223_Daniel
    Icon for Community Champion rankCommunity Champion
    3 years ago

    calculation group can do that job.