Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
2 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
    2 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
2 years ago

HEllo Anonymous ,

 

try this

ROS # £M Web =
    ROUND(
        DIVIDE (
        calculate(SUM('Campaign Overview'[orders]), branch_type = "ONLINE"),
        Calculate(SUM('Campaign Overview'[salesPerMillion]), branch_type = "ONLINE"),
        0
        )
    ,2
    )
 

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 💡

Anonymous's avatar
Anonymous
Not applicable
2 years ago

that returns 0.55 for both online and in store 

because the code will apply the same for the instore reason why it cant be added within the code because the row context will still override it