Measure not showing the total

[emarome94]

Hi guys,

I have created a measure that is showing the value in the report table but not showing the total and I am not able to figure out why would not.

Test =

VAR FY_ = CALCULATE( MAX( 'Price List'[Fiscal Period]), FILTER( 'Accounting', 'Accounting'[Fiscal Period] <= MAX('Price List'[Fiscal Period] ) ) )

return

CALCULATE(

    [Measure0],

   'Accounting'[Fiscal Period] >= FY_ )

Could someone help me to figure it out?

Thank in advance

[v-yadongf-msft · Accepted solution]

Hi @emarome94 ,

This is my test table:

Price list  table:

Accounting table:

Please try following measure:

Measure = SUM('Price List'[Price])

Test = 
VAR _FY =
    CALCULATE (
        MAX ( 'Price List'[Fiscal Period] ),
        FILTER (
            'Accounting',
            'Accounting'[Fiscal Period] <= MAX ( 'Price List'[Fiscal Period] )
        )
    )
VAR _b =
    CALCULATE ( [Measure], 'Accounting'[Fiscal Period] >= _FY )
VAR _c =
    CALCULATE (
        [Measure],
        FILTER ( ALL ( 'Accounting' ), 'Accounting'[Fiscal Period] >= _FY )
    )
RETURN
    IF ( ISINSCOPE ( 'Price List'[ID] ), _b, _c )

Result:

Best regards,

Yadong Fang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.