Trying not to write multiple DAX calculations for the same topic

DAX DAX Calculations
1

Hi

So I am currently building a dashboard for a charity. The charity has multiple funding streams such as;

Funding Type
Grant Funding
Online Funding
Local Funding
Gifted Funding
Corporate Funding

Next to each funding type is the amount received and each funding type can appear multiple times.

There are about 10 funding streams in total.

I have written the following measure to calculate the total funding received;

Total Received =
SUMX(‘Funding Data’,‘Funding Data’[Value awarded])

Each funding stream will have it’s own separate report which will contain a card showing the total received for each funding stream and I have written separate measures for each funding stream below;

Grant Funding Received =
CALCULATE([Total Received],FILTER(‘Funding Data’,‘Funding Data’[Funding Stream] = “Grant Funding”))

Corporate Trust Funding Received =
CALCULATE([Total Received],FILTER(‘Funding Data’,‘Funding Data’[Funding Stream] = “Corporate Trust”))

I am basically copying and pasting each formula multiple times and changing the filter, this seems really basic and will leave me with a huge measures table.

Is there a more advanced, efficient way or tackling this?

1 Like
2

@Josephliverpool Yup, you can use Calculation Groups.

1 Like
3

Interesting! Not something I’ve used before but I will take a look, thanks for the reply, much appreciated!

2 Likes
4

Another option is to put a filter on the entire report to filter the funding type - this could be done in the filter pane or as a slicer that is visible (or not) on the page.

2 Likes
5

Hi @Josephliverpool , did the response provided by the users above help you solve your query?

If not, how far did you get and what kind of help you need further?

If yes, kindly mark as solution the answer that solved your query.

6

Hi @Josephliverpool, we’ve noticed that no response has been received from you since September 28.

We just want to check if you still need further help with this post? In case there won’t be any activity on it in the next few days, we’ll be tagging this post as Solved.

7

Hi @Josephliverpool, due to inactivity, a response on this post has been tagged as “Solution”. If you have any concern related to this topic, please create a new thread or reopen this thread…