Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

Another Sumx ....

Hi   I have a dataset that contains billing for each project for each month. What I am presenting in the matrix is the billing delta versus the prior month for each project (line item).   For the...
Need Help
  • Ashish_Mathur's avatar
    Ashish_Mathur
    5 years ago

    Hi,

    Does this measure work?

    =if(isfiltered('All BPOC Reports'[PROJEKTNR]),[billing vpm],sumx(VALUES('All BPOC Reports'[PROJEKTNR]),[billing vpm]))
Ashish_Mathur's avatar
Ashish_Mathur
Super User
5 years ago

Hi,

Does this measure work?

=if(isfiltered('All BPOC Reports'[PROJEKTNR]),[billing vpm],sumx(VALUES('All BPOC Reports'[PROJEKTNR]),[billing vpm]))
  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    it works Ashish_Mathur  - thank you so much! 🙂

    • Ashish_Mathur's avatar
      Ashish_Mathur
      Super User
      5 years ago

      You are welcome.