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]),
    '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,

 

  • 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,

3 Replies

  • v-yuta-msft's avatar
    v-yuta-msft
    Community Support

    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

      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

        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