Forum Discussion

jiinson's avatar
jiinson
Helper I
9 years ago

Missing Total

 

Dear Tutors,

 

I have had problem getting total values from matrix. As you can tell from the picture, total rows are empty.

I have a slicer that user can choose Top N Number. When user select TopN, there will be only N customers in the matrix. 

 

Those are the measures that I set up for this matrix. 

Btm CY = IF([Btm Rank] <= LOOKUPVALUE('TopN'[TopN No], 'TopN'[TopN], [TopN Selection]), [CY Calc]/1000, BLANK())

Btm PY =

IF(AND([Btm CY] <>0, HASONEFILTER(DM_Costs_Std_USD_Regional[Customer])),

CALCULATE([CY Calc], SAMEPERIODLASTYEAR('Date'[Date].[Date]))/1000,
IF([Btm CY]<> 0, CALCULATE([CY Calc], SAMEPERIODLASTYEAR('Date'[Date].[Date]),

FILTER(ALL(Table[Customer]), [Btm CY]<>0))/1000))

 

What are the reasons that I can't get total value. 

 

Thanks in advance.

 

Best Regards,

Jiin Son

8 Replies

  • Vvelarde's avatar
    Vvelarde
    Community Champion

    jiinson

     

    hi,

    To test purposes please change 

    Btm CY = IF([Btm Rank] <= LOOKUPVALUE('TopN'[TopN No], 'TopN'[TopN], [TopN Selection]), [CY Calc]/1000, BLANK())

     

    to

     

    Btm CY = IF([Btm Rank] <= LOOKUPVALUE('TopN'[TopN No], 'TopN'[TopN], [TopN Selection]), [CY Calc]/1000, 123456)

     

    What is the result