Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

Trend line chart

Hi All,   My table looks like below.   Month Count September 10 October 5   My target per month is 15 September 15 October 30 November 45 December 60 January ...
Need Help
  • Anonymous's avatar
    Anonymous
    4 years ago

    Hi Anonymous ,

    Please update the formula of your measure as below and check whether it can get your expected result.

    Measure =
CALCULATE (
    COUNT ( 'p1'[Name] ),
    FILTER (
        ALLSELECTED ( 'p1' ),
        'p1'[Fiscal Month] <= SELECTEDVALUE ( 'p1'[Fiscal Month] )
    )
)

    By the way, what's the data type of field [Fiscal Month]? It is Numeric or Text type? If it is Text type, the above measure will not return the correct result...

    Best Regards

amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
4 years ago

Anonymous , You need to have a common month /date table. Create a date from the month and then join that with date table on the axis.

 

for the first table, you need cumulative measures. Second one you can use as is 

 

 

Cumm = CALCULATE(SUM('Table'[Count]),filter(allselected(date),date[date] <=max(date[Date])))

  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago
    I have tried calculating cumulative with this query 
    CALCULATE     (
    COUNT('p1'[Name]),
    FILTER (
    ALLSELECTED ('p1'[Fiscal Month]),
    'p1'[Fiscal Month] <= MAX ('p1'[Fiscal Month])
    )
    )
     
    but I'm getting below output
     
    MonthCumm
    September10
    October5
    • Anonymous's avatar
      Anonymous
      Not applicable
      4 years ago

      Hi Anonymous ,

      Please update the formula of your measure as below and check whether it can get your expected result.

      Measure =
CALCULATE (
    COUNT ( 'p1'[Name] ),
    FILTER (
        ALLSELECTED ( 'p1' ),
        'p1'[Fiscal Month] <= SELECTEDVALUE ( 'p1'[Fiscal Month] )
    )
)

      By the way, what's the data type of field [Fiscal Month]? It is Numeric or Text type? If it is Text type, the above measure will not return the correct result...

      Best Regards