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...
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.

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