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

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