Forum Discussion

PshemekFLK's avatar
PshemekFLK
Icon for Helper IV rankHelper IV
8 years ago

Custom tooltip not working for grand total

Hello,

 

I have problems figuring out why the custom tooltip is not working for the Grand Total for the new measure ("Gap to Plan") in my matrix table.

 

The table shows Gap to Plan in dollar value by product category:

 

 

 

If I drag the mouse over the dollar value it shows the custom tooltip that I built:

 

 

This doesn't work however for Total where it still shows the default tooltip:

 

 

Interesting thing is that if I add "Region" to the rows or columns then custom tooltip also works for Grand Total. Why is this happening? 

 

The "Gap To Plan" measure is defined by this formula:

 

Gap To Plan =
 IF(HASONEVALUE('VLookup category'[Category])=FALSE(),SUM('Country_Actual_(OBI)'[Actual]) - SUM('Bi ready'[Plan]),
  CALCULATE (
        SUM ( 'Country_Actual_(OBI)'[Actual] ),
        FILTER ( 'Country_Actual_(OBI)', 'Country_Actual_(OBI)'[Category]=SELECTEDVALUE('VLookup category'[Category]) )

    )
        - CALCULATE (
            SUM ( 'Bi ready'[Plan] ),
            FILTER ( 'Bi ready', LOOKUPVALUE('VLookup category'[Category],'VLookup category'[PFam],'Bi ready'[Pfam])=SELECTEDVALUE('VLookup category'[Category]) )

 

Thanks in advance

Need Help

6 Replies

  • v-juanli-msft's avatar
    v-juanli-msft
    Icon for Community Support rankCommunity Support
    8 years ago

    Hi PshemekFLK

    I can't reproduce your problem.

    the columns added to Tooltips page are "Actual" and "Plan" columns, right?

     

    Best Regards

    Maggie

     

     

    • PshemekFLK's avatar
      PshemekFLK
      Icon for Helper IV rankHelper IV
      8 years ago

      Hi Maggie,

       

      Correct. "Actual" and "Plan" are used in the tooltip. Both fields are from different tables connected by relationship. Again, the most confusing thing about this is that if I add another field to the table the tooltip starts to work on grand total. My feeling is that it has something to do with the dax formula for "Gap to Plan" but not sure. Please let me know if you need more info.

       

      Thanks