Forum Discussion

Regil's avatar
Regil
Frequent Visitor
7 years ago
Solved

Measure for all columns

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]), ...
Need Help
Tutorial Requests
  • v-yuta-msft's avatar
    v-yuta-msft
    7 years ago

    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's avatar
    Regil
    7 years ago

    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's avatar
v-yuta-msft
Community Support
7 years ago

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's avatar
Regil
Frequent Visitor
7 years ago

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's avatar
    v-yuta-msft
    Community Support
    7 years ago

    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