custom measure in a tooltip page

[amalrio]

Hi all, 

I have a tooltip page which works fine as expetec. 

I want a specific measure in that tooltip page that act independed. for instance I want to show sales amout for year 2020 as a tooltip, I have created a measure only getting amounts for 2020

Measure

VAR Total = CALCULATE ( SUM ( 'FACT-Data'[NUMARIC] ), 'DIM-Matrics'[MATRIX_ID] = 9, 'FACT-Data'[YEAR] IN {2020} ) VAR Result = IF ( Total = 0, BLANK (), Total ) RETURN Result+0

Total_2020 =

VAR Total =

CALCULATE ( SUM ( 'FACT-Data'[NUMARIC] ), 'DIM-Matrics'[MATRIX_ID] = 9, 'FACT-Data'[YEAR] IN {2020} )

VAR Result =

IF ( Total = 0, BLANK (), Total )

RETURN

Result+0

when I put this measure in the tooltip page it does not give me the correct number on my report page.

anyone knows how to overcome this issue.

Regards

Amal Eranda

[v-lionel-msft · Accepted solution]

Hi @amalrio ,

Try this.

Total_2020 =
VAR Total =
CALCULATE ( 
   SUM ( 'FACT-Data'[NUMARIC] ), 
   FILTER(
      ALL'DIM-Matrics'),
      'DIM-Matrics'[MATRIX_ID] = 9),
   FILTER(
      ALL('FACT-Data'),
      'FACT-Data'[YEAR] IN {2020} )
)
VAR Result =
IF ( Total = 0, BLANK (), Total )
RETURN
Result+0

 If it is useless, please show sample data.

Best regards,
Lionel Chen

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

[amitchandak]

@amalrio ,Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.