Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
8 years ago
Solved

Using Multiple If or switch in Measures

Hi , I have a list of record in one table which is associated with different school for example like this: School            TeacherperStudent    Date  RV                        100           ...
Data Modeling
  • v-qiuyu-msft's avatar
    v-qiuyu-msft
    8 years ago

    Hi Anonymous,

     

    You can create a measure below:

    WithinTarget = IF(SUM(Table1[TecherperStudent])-SUM(Table2[Target])<=0,1,0)

     

    Then you can set the Conditional Formatting for the column TeacherperStudent. For more information, see attached report. 

     

    Best Regards,
    Qiuyun Yu

v-qiuyu-msft's avatar
v-qiuyu-msft
Icon for Community Support rankCommunity Support
8 years ago

Hi Anonymous,

 

You can create a measure below:

WithinTarget = IF(SUM(Table1[TecherperStudent])-SUM(Table2[Target])<=0,1,0)

 

Then you can set the Conditional Formatting for the column TeacherperStudent. For more information, see attached report. 

 

Best Regards,
Qiuyun Yu