Forum Discussion
Measure to only be applied for a specific row
I have written a measure and of course by default the measure will calculate based on the row context. Is there any way to basically make the measure only calculate for a specific row and then return...
Anonymous Try this .
ROS # £M Web = IF ( SELECTEDVALUE('Campaign Overview'[Type]) = "IN STORE", 0, ROUND ( DIVIDE ( SUM('Campaign Overview'[orders]), SUM('Campaign Overview'[salesPerMillion]) ), 2 ) )
Thanks for the response, that is similar to what I tried but when that happens it just repeats the same value for both like so:
- Idrissshatila
Super User
Hello Anonymous ,
Can you show me your measure?
If I answered your question, please mark my post as solution, Appreciate your Kudos 👍
Follow me on Linkedin
Vote for my Community Mobile App Idea 💡- ROS # £M Web =ROUND(DIVIDE (SUM('Campaign Overview'[orders]),SUM('Campaign Overview'[salesPerMillion])),2)This is the measure but I need it to return 0 for the row of 'IN STORE' but I cannot explicitly do that within the measure because it will just repeat the same value for both.So the output i'm looking for is :
Type ROS #£ Web IN STORE 0 ONLINE 0.55
