Forum Discussion
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 Procedures | % Of Usage |
| 1221 | 924.902 | REV | REV Ti | JP | JP | Used | 48 | 50 | 96% |
| 1221 | 924.902 | REV | REV Ti | JP | TS | Shared | 2 | 50 | 4% |
My requirement:
I nead to create a flag in No of procedures, to differentiate Used and Shared values like this.
Only if shared procedure is greated than used procedures, i need to show green flag over there, else i need to show red flag.
I'm dont know about compare the measure resultant values.
Please advice how to compare this values.
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.
1 Reply
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.