Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago
Solved

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...
Need Help
  • Anonymous's avatar
    Anonymous
    3 years ago

    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 ) )

Idrissshatila's avatar
Idrissshatila
Icon for Super User rankSuper User
3 years ago

Hello Anonymous ,

 

yes sure try this

 

New measure =
var ONLINE = calculate ( "Add here the ROS #£M Web calculation " , branch_type = "ONLINE")
return

if ( ONLINE = blank(), 0, ONLINE)

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 💡