Forum Discussion

kasai16's avatar
kasai16
Regular Visitor
2 years ago
Solved

Convert Tableau color formula to Power Bi

Hi,

 

I want below Tableau calculated field to be worked in power BI (Measure or Column) as i have to give the color basis on the value available in Power BI.

 

IF ZN([Calculation) = 0 THEN "No Qty in Scenario"
ELSEIF (ZN([Calculation]) - LOOKUP(ZN([Calculation]),FIRST())) = 0 THEN "Qty = Baseline"
ELSEIF (ZN([Calculation]) - LOOKUP(ZN([Calculation]),FIRST())) > 0 THEN "Qty > Baseline"
ELSEIF (ZN([Calculation]) - LOOKUP(ZN([Calculation]),FIRST())) < 0 THEN "Qty < baseline"

Need Help
  • bhanu_gautam's avatar
    bhanu_gautam
    2 years ago

    kasai16 , First create a measure for calculation


    Calculation = SUM('YourTable'[YourColumn])

     

    Then for Lookup value


    BaselineValue =
    CALCULATE(
    [Calculation],
    FIRSTNONBLANK('YourTable'[YourColumn], 1)
    )

     

    In the end final measure for conditional logic

    dax
    QtyStatus =
    VAR CurrentCalculation = [Calculation]
    VAR BaselineCalculation = [BaselineValue]
    RETURN
    IF(
    ISBLANK(CurrentCalculation) || CurrentCalculation = 0,
    "No Qty in Scenario",
    IF(
    CurrentCalculation - BaselineCalculation = 0,
    "Qty = Baseline",
    IF(
    CurrentCalculation - BaselineCalculation > 0,
    "Qty > Baseline",
    "Qty < Baseline"
    )
    )
    )

     

    Now you can use QTY status in conditional formatting of visual

     

1 Reply

  • bhanu_gautam's avatar
    bhanu_gautam
    Icon for Super User rankSuper User
    2 years ago

    kasai16 , First create a measure for calculation


    Calculation = SUM('YourTable'[YourColumn])

     

    Then for Lookup value


    BaselineValue =
    CALCULATE(
    [Calculation],
    FIRSTNONBLANK('YourTable'[YourColumn], 1)
    )

     

    In the end final measure for conditional logic

    dax
    QtyStatus =
    VAR CurrentCalculation = [Calculation]
    VAR BaselineCalculation = [BaselineValue]
    RETURN
    IF(
    ISBLANK(CurrentCalculation) || CurrentCalculation = 0,
    "No Qty in Scenario",
    IF(
    CurrentCalculation - BaselineCalculation = 0,
    "Qty = Baseline",
    IF(
    CurrentCalculation - BaselineCalculation > 0,
    "Qty > Baseline",
    "Qty < Baseline"
    )
    )
    )

     

    Now you can use QTY status in conditional formatting of visual