Forum Discussion

NavaneethaRaju's avatar
NavaneethaRaju
Helper IV
4 years ago
Solved

Need help with Measure

Hi,   I need the measure for comparing measure resultant values like the condition.  Tag ID Set ID Set Description System Tag Owner Order Owner Usage Type No. Of Procedures Total Proced...
Need Help
Show and Tell
  • v-zhangti's avatar
    v-zhangti
    4 years ago

    Hi, NavaneethaRaju 

     

    There is nothing wrong with your method, the formula needs to be modified a little.

    U = CALCULATE([No. Of Procedures], FILTER(ALL('Tag Usage Fact'),[Usage Type]="Used"))
    S = CALCULATE([No. Of Procedures],FILTER(ALL('Tag Usage Fact'),[Usage Type]="Shared"))
    Comp(U&S) = IF([U]<[S],1,0)

    Is this the result you expect?

     

    Best Regards,

    Community Support Team _Charlotte

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

v-zhangti's avatar
v-zhangti
Community Support
4 years ago

Hi, NavaneethaRaju 

 

There is nothing wrong with your method, the formula needs to be modified a little.

U = CALCULATE([No. Of Procedures], FILTER(ALL('Tag Usage Fact'),[Usage Type]="Used"))
S = CALCULATE([No. Of Procedures],FILTER(ALL('Tag Usage Fact'),[Usage Type]="Shared"))
Comp(U&S) = IF([U]<[S],1,0)

Is this the result you expect?

 

Best Regards,

Community Support Team _Charlotte

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