Forum Discussion

Zainhashmi's avatar
Zainhashmi
Regular Visitor
5 years ago
Solved

Calculating Custom Measure for Matrix

Hi..

 

i need help with my measure below..

 

 

i am creating a measure for custom calculation.. the criteria is if the created measure has the value greater than '"0" than it should return the spending otherwise blank.. the formula working on row by row is perfectly fine

but for the totals.. it is showing the same amount of spend which is incorrect.. in this case where i am making the mistake.. would be very glad for your expert opinon.. 

Thanks

 

Need Help
  • v-lionel-msft's avatar
    v-lionel-msft
    5 years ago

    Hi Zainhashmi ,

     

    Please refer to my formula.

     

    Best regards,
    Lionel Chen

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

4 Replies

  • DataZoe's avatar
    DataZoe
    Microsoft Employee
    5 years ago

    Zainhashmi You could try and add on line 47 (after the RETURN) a SUMX like so:

    SUMX(VALUES('Table'[Vendor Name]),

     

    then add another ) at the very end. That way it will figure it out per vendor (you can also do it for each row of the table if you drill down), then sum them up.

    • Zainhashmi's avatar
      Zainhashmi
      Regular Visitor
      5 years ago

      so when i am trying to aggregate it... it doesn't show the formula as seen below:

      • DataZoe's avatar
        DataZoe
        Microsoft Employee
        5 years ago

        Zainhashmi Can you try doing it as a new measure? Verified Total = sumx(values(table[vendor name]),[Verified])

  • v-lionel-msft's avatar
    v-lionel-msft
    Community Support
    5 years ago

    Hi Zainhashmi ,

     

    Please refer to my formula.

     

    Best regards,
    Lionel Chen

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