How to show total amount

[Chumtsoe_2024]

I want show the total amount of grants..but I cannot do so without showing the filters that I used to exclude certain variables.

Like this:

Thank you. 

[Chumtsoe_2024]

Hi Phil,

Thanks for the response.

I would like to retrieve the total amount of all grants.However I need to filter out some data.

I want to visualise all the grants but I am not able to do so as I can also view all the filters I use to filter out the total amount.

[PhilipTreacy]

Hi @Chumtsoe_2024 

Your question is a bit vague and you've supplied no sample data to help us

Re: How to Get Your Question Answered Quickly - Page 5 - Microsoft Fabric Community

Maybe you need something like this

COUNTROWS(ALL(Table))

Phil