Forum Discussion
Filter based select slicer
Hello cummunity ,i wanna create a mesure that allow me to reduce colomn value "Value" , (there is a specific value for each selected slicer item ) based on selected slicer and , i used switch fuction and i don't know how to fix it , Thank you
reduce_value = IF(HASONEVALUE(Historics[item-name]),
SWITCH( SELECTEDVALUE(Historics[item-name]),
"Area Harvested", CALCULATE(Historics,Historics[Value]>20000) ,
"Cane Crush", CALCULATE(Historics,Historics[Value]>2000000000),
"CCS",CALCULATE(Historics,Historics[Value])>12,
"Sugar Production",CALCULATE(Historics,Historics[Value])>200000,
"Yield",CALCULATE(Historics,Historics[Value])>60,"N/A")
)
Hi MAJ_1205 ,
Could you please explain what function or result you are trying to achieve with the above measure? Do you want to get the data in the table below? Could you please provide some raw data (exclude sensitive data) of the table 'Historics'. Thank you.
item-name Value Area Harvested the sum of value which the value is greater than 20000 Cane Crush the sum of value which the value is greater than 2000000000 CCS the sum of value which the value is greater than 12 Sugar Production the sum of value which the value is greater than 200000 Yield the sum of value which the value is greater than 60 Oter item names N/A Best Regards
1 Reply
Hi MAJ_1205 ,
Could you please explain what function or result you are trying to achieve with the above measure? Do you want to get the data in the table below? Could you please provide some raw data (exclude sensitive data) of the table 'Historics'. Thank you.
item-name Value Area Harvested the sum of value which the value is greater than 20000 Cane Crush the sum of value which the value is greater than 2000000000 CCS the sum of value which the value is greater than 12 Sugar Production the sum of value which the value is greater than 200000 Yield the sum of value which the value is greater than 60 Oter item names N/A Best Regards