Forum Discussion

posterme's avatar
posterme
Frequent Visitor
8 years ago

Slicer - How can I count selected months?

Hi Guys,   how can I or is it possible to count how many months I have selected in a Date-Slicer? I want to divide a value with the count of monts, e.g. earnings / selected months ... All variants ...
Need Help
posterme's avatar
posterme
Frequent Visitor
8 years ago

Hi,

 

I have tested both ISFILTERED and ISCROSSFILTERED - below you'll find the screenshot from the table field:

 

 

Slicer (Timeline) is configured only with the "Date" field:

 

 

Again - many thanks for your support :)

 

vega's avatar
vega
Icon for Resolver III rankResolver III
8 years ago

Does your date table have a months column?

  • posterme's avatar
    posterme
    Frequent Visitor
    8 years ago

    Hi, its only a column defined as date field...

     

    UPDATE:

     

    And as I written in my first message,

     

    with COUNT('TABLE'[Date].[Month]) the Value is 1096,

    with DISTINCTCOUNT('TABLE'[Date].[Month]) it is 12 ...

     

    But what is "1096" ? :)

    • vega's avatar
      vega
      Icon for Resolver III rankResolver III
      8 years ago

      I believe 1096 is the number of dates in your date column