Forum Discussion

pstp's avatar
pstp
Frequent Visitor
5 years ago
Solved

Date Dimension Table and Calculating Averages

I have a fact table with event attendance that has multiple data points for the same day/week (for different locations and times). I also have a master date dimension table. The two tables are relate...
Need Help
  • nvprasad's avatar
    nvprasad
    5 years ago

    Hi 

    Can you try with belwo dax?

     

    Average = SUM(Fact_Table[YValue]) / CALCULATE(DISTINCTCOUNT(Dim_Date_Table[CalendarWeekNumber],FACTTABE[DATECOLUMN]))

    Appreciate a Kudos! 🙂
    If this helps and resolves the issue, please mark it as a Solution! 🙂

    Regards,
    N V Durga Prasad

nvprasad's avatar
nvprasad
Icon for Solution Sage rankSolution Sage
5 years ago

Hi 

Can you try with belwo dax?

 

Average = SUM(Fact_Table[YValue]) / CALCULATE(DISTINCTCOUNT(Dim_Date_Table[CalendarWeekNumber],FACTTABE[DATECOLUMN]))

Appreciate a Kudos! 🙂
If this helps and resolves the issue, please mark it as a Solution! 🙂

Regards,
N V Durga Prasad