Forum Discussion
sakuragihana
Helper IV
Helper IVNeed help for improving my dax
Hello everyone, I have 2 table below : Table 1: Table 2: Table 2 is explained below : Condition : 1.% New Std PD and Re open vs Target >= 90% 2.If % Ne...
bhelou
Responsive Resident
Responsive ResidentDear ,
i updated a bit in the PBIX file :
1- i created a table for bonus levels
2- Updated the measure
https://www.dropbox.com/s/m8lx0d2hrnqfp9q/Bonus%20Campus.pbix?dl=0
/// in the measure Bonus Campus_Test : replace the value if condition is true and false with the appropriate values for your case
Kindly check the updated PBIX file and let me know the approach is correct or no .
Kindly accept as a solution and a kudo is appreciated .
Thanks .
Hi bhelou ,
The dax that you made was wrong because the new table bonus levels didn't have campus code