Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
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")
)
Solved! Go to Solution.
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
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
User | Count |
---|---|
83 | |
70 | |
69 | |
66 | |
53 |
User | Count |
---|---|
94 | |
92 | |
91 | |
77 | |
70 |