How to remove page filters from in-text value

[syzygyamteam]

Hi everyone,

I am trying to show a generation vs forecast percentage using powerbi but drawing from a seperate spreadsheet. 

On the page, I want to be able to show the SUM(tbDailyOutputSummary[TGM Output (kWh)])/SUM(tbDailyOutputSummary[Business Case Target (kWh)]) for a specific period as well as a to date summary.

At the moment, the page filters specify just the period, therefore the formula does not allow me to show a to date percentage.

It is not a measure, which I have seen how to use and have been able to get the correct figure using that method, however, this I can only present as a visual rather than an in-text formula.

If someone could help me with this I would be grateful.

Best regards,

[Anonymous]

Hi  @syzygyamteam ,

It's not clear what you mean, are you trying to display the data so far unaffected by the page filter

Measure=
SUMX(
    FILTER(ALL(tbDailyOutputSummary),
    'tbDailyOutputSummary'[Date]>=DATE(YEAR(TODAY()),1,1)&&'tbDailyOutputSummary'[Date]<=TODAY()),[summary])

You can use pictures to show the results you want, and we can help you better

This is the related document, you can view this content:

Solved: Stop Page Level Filter From Applying to One Visual - Microsoft Power BI Community

Solved: Need one Visual to ignore a Page Filter - Microsoft Power BI Community

Best Regards,

Liu Yang

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