Forum Discussion

MaQaN's avatar
MaQaN
Frequent Visitor
5 years ago
Solved

Need support with Calculated measures

Hello, I have a problem that I need help with as I’m unable to find a solution myself.   I currently have a table visualization set up as bellow where I’m summarizing data from multiple query’s. ...
General Comment
Need Help
Show and Tell
Tips and Tricks
Tutorial Requests
  • v-deddai1-msft's avatar
    v-deddai1-msft
    5 years ago

    Hi MaQaN ,

     

    Use the measure below:

     

    Measure = CALCULATE(MAX('Table'[Stock Zone]),FILTER(ALL('Table'),'Table'[Order line number] = MAX('Table'[Order line number])&&'Table'[Location] IN{ "ZZ", "OO", "YY" ,"XX"}))

     

     

    For more details, please refer to the pbix file.

     

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

     

    Best Regards,

    Dedmon Dai

m3tr01d's avatar
m3tr01d
Continued Contributor
5 years ago

Hi MaQaN 

can you clarify for Line number 5 why is the last column is showing Z?
What is the rule to compute the last column?

  • MaQaN's avatar
    MaQaN
    Frequent Visitor
    5 years ago

    Hello m3tr01d,

    A new order line number is generated for each distinkt part on the same Delivery number. So the delivery number 1000000023 from the table consist of atleast 5 difrent parts.

    Example:

    Deliver number 1000000023

    Line 1 = Phone

    Line 2 = Computer

    Line 3 = Headset

    ...

    All these parts will then go on and be delivered to customer that placed the Order number for specified delivery number.

     

    "What is the rule to compute the last column?"

    As for the last column showing Z is what im trying to accomplise. It's should show me the specifik Stock Zone that im intrested in on each order line and where it previus have been to.

     

    In my mind im thinking something like:

    IF Stock Zone is "AA" then "Z" en return "Z" as long as Delivery number & Order line number is the same.