Measure for all columns

[Regil]

Hi,

Thanks in advance for reading my post. Newbie here and learning about measures. I have my measure below:

Grant Pipeline Submitted =
CALCULATE(
    SUM('Master List Pipeline'[Amount]),
    'Master List Pipeline'[Approval Status]
        IN { "Submitted Proposals - unknown", "Submitted Proposals - likely", "Approved"},
        'Master List Pipeline'[FY Group] = "FY18 Donor"
)      

And the output is here:

 

 My code above is able to SUM "FY18 Donor" column (under FY 18) only. What I would like to know is how to perform SUM for all the other columns in all FY (FY18 to FY22). (i.e. FY18 Match, FY 18 Total Match-Fully Loaded, FY18 WVC Op Costs, FY19 Donor, FY19 Match,,,,, and so on)

 

I know it is automatically summarized (as seen in the visual above) but I want to put this in measure so I can reuse/call it again in other computation.

Appreciate your help.

Thanks,

[v-yuta-msft · Accepted solution]

@Regil,

---

My code above is able to SUM "FY18 Donor" column (under FY 18) only. What I would like to know is how to perform SUM for all the other columns in all FY (FY18 to FY22). (i.e. FY18 Match, FY 18 Total Match-Fully Loaded, FY18 WVC Op Costs, FY19 Donor, FY19 Match,,,,, and so on) 

Could you clarify more details about the logic of "SUM other columns" and share some sample data about the original table(not the matrix chart)?

Community Support Team _ Jimmy Tao

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

[v-yuta-msft · Accepted solution]

@Regil,

---

My code above is able to SUM "FY18 Donor" column (under FY 18) only. What I would like to know is how to perform SUM for all the other columns in all FY (FY18 to FY22). (i.e. FY18 Match, FY 18 Total Match-Fully Loaded, FY18 WVC Op Costs, FY19 Donor, FY19 Match,,,,, and so on) 

Could you clarify more details about the logic of "SUM other columns" and share some sample data about the original table(not the matrix chart)?

Community Support Team _ Jimmy Tao

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

[Regil · Accepted solution]

@v-yuta-msft

Hello,

Thank you so much for looking into this.

This is okay now, there were some things unclear to me at first but this is working now.

Again thank you so much for your time.

Regards,

[v-yuta-msft]

@Regil,

Great to hear that. could you please help mark the correct answer to finish the thread? Your contribution will be much appreciated.

Regards,

Jimmy Tao