Home Forums Power Pivot Conditional Measure

This topic contains 2 replies, has 2 voices, and was last updated by  LFCIan 6 months, 1 week ago.

Viewing 3 posts - 1 through 3 (of 3 total)
  • Author
    Posts
  • #8710

    LFCIan
    Participant
    • Started: 1
    • Replies: 1
    • Total: 2

    I am trying to create a measure that has multiple conditions. For example. I want to be able to switch the percent sign on a measure result based on an account number within a range. Can you help

    #8712

    dircur
    Participant
    • Started: 14
    • Replies: 31
    • Total: 45

    You may want to give an example. From what you’ve described it is difficult to know what you want. You appear to be asking for the value to be presented differently but essentially the same calculation? or does the account number alter the calc method. I don’t have any suggestions but I would guess others might not understand what you are looking for.

    #8717

    LFCIan
    Participant
    • Started: 1
    • Replies: 1
    • Total: 2

    ok, here goes. I have three measures as follows

    [OperRevVar]

    [OperExpVar]

    [OpNonOpVar]

    I want to be able to use one of the measure depending on the section of my income statement the measure calculates. In simple terms I want to say

    IF (Income Statement Group = “Operating Revenue” then [OperRevVar]

    IF (Income Statement Group = “Operating Expense” then [OperExpVar]

    else [OpNonOpVar]

    I have tried the Switch Statement as follows but can’t get it to work

    Conditional_Measure:=IF(HASONEFILTER(LVL_GRP[Level_Group]),SWITCH(VALUES(LVL_GRP[Level_Group]),”Operating Expense”,[OpExVar],”Operating Revenue”,[OpRevVar]),[OpNonOpVar])

     

    Thanks

Viewing 3 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic.