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.

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