DAX PROBLEM

[jamc]

Hi guys 

I am looking for a Dax Solution for the current predicament I have created a table where all the information is previoulsy extracted and calculated from their corresponding tables to the current view. Currently this how is dispay in my PBI

Now the next step under Column Status I want to identify the opportunity If the excess of one Company (column in blue) is < the shortage of the others companies column Yellow,

I tried to nest the information by using th If Function and even try the Switch(true() function without succes, hope that you can helop me display the data

Kind Regards

[Wilson_ · Accepted solution]

Hello jamc,

Knowing nothing about your data model, something like the below should work. I assumed that excess/shortage were measures and that company was a column in the table. Adjust the measure as necessary.

Status =
VAR CompanyAExcess =
CALCULATE (
    [Excess],
    REMOVEFILTERS ( Table1[Company] ),
    Table1[Company] = "Company A"
)
VAR CompanyBShortage =
CALCULATE (
    [Shortage],
    REMOVEFILTERS ( Table1[Company] ),
    Table1[Company] = "Company B"
)
VAR CompanyCShortage =
CALCULATE (
    [Shortage],
    REMOVEFILTERS ( Table1[Company] ),
    Table1[Company] = "Company C"
)

RETURN
IF (
    CompanyAExcess <= MAX ( CompanyBShortage, CompanyCShortage ),
    "Opportunity"
)

----------------------------------
If this post helps, please consider accepting it as the solution to help other members find it quickly. Also, don't forget to hit that thumbs up and subscribe! (Oh, uh, wrong platform?)