Convert Tableau color formula to Power Bi

[kasai16]

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"

[bhanu_gautam · Accepted solution]

@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