Forum Discussion

GlitchedDuck's avatar
GlitchedDuck
Frequent Visitor
4 years ago

Average Count Per Day/Week/Month Card

Hi All,   I'm trying to create a few card visualization that shows average amount of invoices per Day/Week/Month.   In my data i have created_date, Invoice_Number and want to show the average in ...
Need Help
davehus's avatar
davehus
Memorable Member
4 years ago

Hi GlitchedDuck ,

 

Assuming you are looking to discount invoices in your fact table.

 

Invoice Count = DISTINCTCOUNT(Table[InvoiceColumn]) 

 

Day = Averagex(Values(DateTable[Day]), [Invoice Count])

Week = Averagex(Values(DateTable[Week]), [Invoice Count])

Month = Averagex(Values(DateTable[Month]), [Invoice Count])

 

HTH

  • GlitchedDuck's avatar
    GlitchedDuck
    Frequent Visitor
    4 years ago

    Thist just seems to be giving me back the total number of invoices 

    • Tahreem24's avatar
      Tahreem24
      Super User
      4 years ago

      GlitchedDuck Wrap it with DAY function.

      Day = Averagex(Values(DAY(DateTable[DateColumn])), [Invoice Count])

       

    • davehus's avatar
      davehus
      Memorable Member
      4 years ago

      Have you a date table linked to your Invoice Header? The Date part of the measure I provided needs to be passed through the date table and not the fact table. Hence why you're getting everything. It provides the context for the average.

       

      • GlitchedDuck's avatar
        GlitchedDuck
        Frequent Visitor
        4 years ago

        I have a Date_Dim table thats joins to my Invoice_Table and it shows the same results. I can do an actual count by day with no issues, but when i add the average it gives me a total count of invoices