Forum Discussion

haimoww's avatar
haimoww
New Member
3 years ago
Solved

Daily Based Sales Percentages

Hi all,

 

A basic question i want to ask, how can i add a new metric for the daily based sales amount by percentages.

(Total Monday sales / Total Net Sales)

Please find the image below;

eg. Pazartesi (Monday) 18,2%

DayOfWeekName in DATES Table

Total Net Sales (Metric) in SALES REPORT Table

 

Ty in advance

 

Need Help
  • DimaMD's avatar
    DimaMD
    3 years ago

    haimoww Check the relationships between the date table and the fact table

     

3 Replies

  • DimaMD's avatar
    DimaMD
    Icon for Solution Sage rankSolution Sage
    3 years ago

    Hi, haimoww You need the next measure

     

    prct = 
 DIVIDE(  [TotalNetSales], 
 CALCULATE( [TotalNetSales],ALLSELECTED('dates'[DayOfWeekName]))
 )

     

     

    • haimoww's avatar
      haimoww
      New Member
      3 years ago

      Thank you so much for your quick response but whats wrong with the %s here, what did i do wrong?

       

       

      • DimaMD's avatar
        DimaMD
        Icon for Solution Sage rankSolution Sage
        3 years ago

        haimoww Check the relationships between the date table and the fact table