Forum Discussion

posterme's avatar
posterme
Frequent Visitor
8 years ago
Solved

Difference Distinctcount (formula) <-> Count (Distinct) within value

Hi,   where is the difference between the formula "DISTINCTCOUNT" and the "Count (Distinct)" within some visuals?   I do have a date/mont slicer, select 4 months. If I create a table with date an...
Need Help
  • posterme's avatar
    posterme
    8 years ago

    Hi,

     

    I have a "workaround":

     

    Measure 1: Month_Name = 'Sales'[Date].[Month]

     

    Measure 2: Month_Count = DISTINCTCOUNT('Sales'[Month_Name])

     

    And then I can create a Measure: Average = 'Sales'[Turnover] / [Month_count]

Greg_Deckler's avatar
Greg_Deckler
Community Champion
8 years ago

OK, I see that, but I need sample data to recreate. Preferrably sample data that I don't have to manually type so something that I can copy and paste into an Enter Data query and then create calculations. I don't need the actual data, I just need a small portion of data that emulates your data.

posterme's avatar
posterme
Frequent Visitor
8 years ago

Hey Greg,

 

thanks. I will try to export some data an recreate my scenario.

But maybe I can explain it a little bit easier or maybe I think to difficult: I need the Count of the selected month from the slicer to divide sales with the count of month, e.g. 1.000.000 $ Sales in 3 month (selected are FEB,MAR & APR) = 333.333,33 $ per month (so I have an average from this 3 months)...

 

Thanks!

  • posterme's avatar
    posterme
    Frequent Visitor
    8 years ago

    Hi,

     

    I have a "workaround":

     

    Measure 1: Month_Name = 'Sales'[Date].[Month]

     

    Measure 2: Month_Count = DISTINCTCOUNT('Sales'[Month_Name])

     

    And then I can create a Measure: Average = 'Sales'[Turnover] / [Month_count]

  • Greg_Deckler's avatar
    Greg_Deckler
    Community Champion
    8 years ago

    I would have never figured that out from your first two posts. In that case, the answer is quite simple:

     

    Number of Months = COUNTROWS(DISTINCT(Calender[Month]))

    A little explanation goes a long way.