Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hi,
How can I check if the Column matches a value to set a value in a measure. This is what I am trying to achieve.
Thanks in advanced
Power Bi report below
https://www.dropbox.com/s/dqsg36arrimeqk7/Power%20BI%20Sample.pbix?dl=0
Solved! Go to Solution.
@nmaddock Please find the updated measure calculation in the pbix file attached. Check and let me know if any isssues.
Proud to be a PBI Community Champion
@nmaddock Please find the updated measure calculation in the pbix file attached. Check and let me know if any isssues.
Proud to be a PBI Community Champion
Perfect, thank you
I do not have the answer to your question, but from what you are trying to you acheive, i think it would be better to create a calculated column. and utilizing related function, use the disposal costs whereever required.
Hi,
Assuming that you want to match the selected value from the Material Type slicer to Glass or Cardboard, you can use the below mentioned formula for your measure.