Forum Discussion
IF ELSE?
Hello, My IF ELSE is not working. Is there any alternative for this? Can someone help me create a logic that will classify POR column, it is a calculated column which i would need to divide i...
Anonymous
if you want to filter , you can change the column to
POR 300 CUTOFF = IF(CALCULATE(sum(Table1[POR]),ALLEXCEPT(Table1,Table1[Project Number]))>300000,"high","low")and use that column in the slicer visual
Hi, ryan_mayu
I see, so it's a row level perspective. how about in showing the high and low in the specific view, like this:
POR is showing high values but the result is still low
Anonymous
You can try this
Measure = if(SUM(Table1[POR])>300000,"HIGH","LOW")
ryan_mayu thank you! but how do i use this measure as a filter for high and low values?
Anonymous
if you want to filter , you can change the column to
POR 300 CUTOFF = IF(CALCULATE(sum(Table1[POR]),ALLEXCEPT(Table1,Table1[Project Number]))>300000,"high","low")and use that column in the slicer visual