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 se...
Need Help
Show and Tell
Tips and Tricks
Tutorial Requests
Vvelarde's avatar
Vvelarde
Community Champion
9 years ago

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

jiinson's avatar
jiinson
Helper I
9 years ago

Vvelarde


The result is this. 

  • Vvelarde's avatar
    Vvelarde
    Community Champion
    9 years ago

    jiinson

     

    What is the total that you expected. The sum of the column in the table?

     

     

     

     

     

     

    • jiinson's avatar
      jiinson
      Helper I
      9 years ago

      Vvelarde

       

      I expect 31 for Btm PY and -11 for Btm CY.

       

      Thanks,

      Jiin Son

      • Vvelarde's avatar
        Vvelarde
        Community Champion
        9 years ago

        jiinson

         

        Ok, in this scenario you need to create the dax Part to calculate the totals, because your actual measure don't made this.

         

        I can help you with that but i need sample data to do it.