Forum Discussion
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
- VvelardeCommunity Champion
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