Forum Discussion
how to use multiple condition using measure
What is the PriorityScore meaning?
Is that:
- a constant value in each field
- or is that a filtered value from a slicer?
If it's a constant per represented group then you can consider using AVG('Efficiency Matrix'[PriorityScore])) to get what you want.
7 Replies
- 1Daniel993
Helper III
Hi you can try:
priorityscore = IF ( 'Efficiency Matrix'[sum of scorecard] >= 20 && 'Efficiency Matrix'[sum of scorecard] <= 40, 10,0 ) - bolfri
Solution Sage
Conditions:
You have a table with columns [priorityscore] and [scorecard]. Both are numbers.
Syntax for column:
Column = SWITCH(TRUE(), [priorityscore] = 0, 0, [priorityscore] > 0 && [scorecard]>=20 && [scorecard]<=40,10, [scorecard]>=20 && [scorecard]<=40,10 )Syntax measure:
Measure = SWITCH(TRUE(), SUM([priorityscore]) = 0, 0, SUM([priorityscore]) > 0 && SUM([scorecard])>=20 && SUM([scorecard])<=40,10, SUM([scorecard])>=20 && SUM([scorecard])<=40,10 )Depending on your data you and what values you want to achive you need to consider using SUMX except SUM eg. if you need to SUM only a score with priority higher than 0. My syntax measure do not apply that rule.
If it's not the case, you can use it.
If it's a problem - give us a sample rows and logic that you want to apply.
- krishanw
Helper II
Hi
I need to write condition as below. Without getting the sum of the [PriorityScore], I want to pass the exact value
Measure 3 = SWITCH(TRUE(),'Efficiency Matrix'[sum of scorecard]>=10 && 'Efficiency Matrix'[sum of scorecard]<=20 && 'Efficiency Matrix'[PriorityScore])=1,10,'Efficiency Matrix'[sum of scorecard]>=21 && 'Efficiency Matrix'[sum of scorecard]<=30 && 'Efficiency Matrix'[PriorityScore])=1,20,'Efficiency Matrix'[sum of scorecard]>=10 && 'Efficiency Matrix'[sum of scorecard]<=20 && 'Efficiency Matrix'[PriorityScore])=2,30,'Efficiency Matrix'[sum of scorecard]>=21 && 'Efficiency Matrix'[sum of scorecard]<=30 && 'Efficiency Matrix'[PriorityScore])=2,40- bolfri
Solution Sage
What is the PriorityScore meaning?
Is that:
- a constant value in each field
- or is that a filtered value from a slicer?
If it's a constant per represented group then you can consider using AVG('Efficiency Matrix'[PriorityScore])) to get what you want.
- krishanw
Helper II
Also, I tried using columns
Please see the sample
IF('Efficiency Matrix'[PriorityScore]=3 && [ScoreCard]=0 ,12,IF('Efficiency Matrix'[PriorityScore]=3 && [ScoreCard]<=1 && [ScoreCard]>=10 ,11,IF('Efficiency Matrix'[PriorityScore]=3 && [ScoreCard]<=11 && [ScoreCard]>=20,10,IF('Efficiency Matrix'[PriorityScore]=3 && [ScoreCard]<=21 && [ScoreCard]>=30,9,IF('Efficiency Matrix'[PriorityScore]=3 && [ScoreCard]<=31 && [ScoreCard]>=40,8 ,IF('Efficiency Matrix'[PriorityScore]=3 && [ScoreCard]<=41 && [ScoreCard]>=50,7,IF('Efficiency Matrix'[PriorityScore]=3 && [ScoreCard]<=51 && [ScoreCard]>=60,6,IF('Efficiency Matrix'[PriorityScore]=3 && [ScoreCard]<=61 && [ScoreCard]>=70,5,IF('Efficiency Matrix'[PriorityScore]=3 && [ScoreCard]<=71 && [ScoreCard]>=80,4,IF('Efficiency Matrix'[PriorityScore]=3 && [ScoreCard]<=81 && [ScoreCard]>=90,3,IF('Efficiency Matrix'[PriorityScore]=3 && [ScoreCard]<=91 && [ScoreCard]>=100,2,IF('Efficiency Matrix'[PriorityScore]=3 && [ScoreCard]<=100 ,1,--P4IF('Efficiency Matrix'[PriorityScore]=4 && [ScoreCard]=0 ,11,IF('Efficiency Matrix'[PriorityScore]=4 && [ScoreCard]<=1 && [ScoreCard]>=10 ,10,IF('Efficiency Matrix'[PriorityScore]=4 && [ScoreCard]<=11 && [ScoreCard]>=20,9,IF('Efficiency Matrix'[PriorityScore]=4 && [ScoreCard]<=21 && [ScoreCard]>=30,8,IF('Efficiency Matrix'[PriorityScore]=4 && [ScoreCard]<=31 && [ScoreCard]>=40,7 ,IF('Efficiency Matrix'[PriorityScore]=4 && [ScoreCard]<=41 && [ScoreCard]>=50,6,IF('Efficiency Matrix'[PriorityScore]=4 && [ScoreCard]<=51 && [ScoreCard]>=60,5,IF('Efficiency Matrix'[PriorityScore]=4 && [ScoreCard]<=61 && [ScoreCard]>=70,4,IF('Efficiency Matrix'[PriorityScore]=4 && [ScoreCard]<=71 && [ScoreCard]>=80,3,IF('Efficiency Matrix'[PriorityScore]=4 && [ScoreCard]<=81 && [ScoreCard]>=90,2,IF('Efficiency Matrix'[PriorityScore]=4 && [ScoreCard]<=91 && [ScoreCard]>=100,1,IF('Efficiency Matrix'[PriorityScore]=4 && [ScoreCard]<=100 ,0.5)
- krishanw
Helper II
Hi
I need to write condition as below. Without getting the sum of the [PriorityScore], I want to pass the exact value
Measure 3 = SWITCH(TRUE(),'Efficiency Matrix'[sum of scorecard]>=10 && 'Efficiency Matrix'[sum of scorecard]<=20 && 'Efficiency Matrix'[PriorityScore])=1,10,'Efficiency Matrix'[sum of scorecard]>=21 && 'Efficiency Matrix'[sum of scorecard]<=30 && 'Efficiency Matrix'[PriorityScore])=1,20,'Efficiency Matrix'[sum of scorecard]>=10 && 'Efficiency Matrix'[sum of scorecard]<=20 && 'Efficiency Matrix'[PriorityScore])=2,30,'Efficiency Matrix'[sum of scorecard]>=21 && 'Efficiency Matrix'[sum of scorecard]<=30 && 'Efficiency Matrix'[PriorityScore])=2,40