Status update runtime in column

[Anonymous]

Team,

Status Column is not working fine on filter. As I selected multiple prodid, it shows the coorect status, as I select one prodid, its not changed. Measure is working fine but I need column because I have to use it bar chart as well. 
 

I have columns: itemid, prodid, ReqQTY, OHQTY, NTOQTY, ORDQTY and status.
same item can exits in more then one prodid. I have implemented the SUM with the allexpect on the basis of itemid, to accumulate their quantity on the basis of multiple prodid section.
I created status conditional column with the values, OH, NTO, Ordered, OH/NTO, OH/Ord and partially ordered. But its now not showing the correct status. It's not changing the status on runtime, specially items exits in multiple prodid and different status, but its keeping the status same instead of changing on rum time.
I cannot create the measure. I have to create calculated column because I also have to use it in the x-axis of the bar chart as well.
I also tried different technique included calculated table to fulfil the requirements

could you please help me?

 

 

[sayaliredij]

Hello @Anonymous ,

Unfortunately, the calculated column remains immutable until the table undergoes processing. I also attempted to utilize a calculated table, but it persists with the value created at processing time and lacks dynamism.

If you require a dynamic status, creating a measure seems to be the viable option. For instance, if you wish to ascertain the count of distinct items based on the selected prodname, I suggest using a measure and employing it on the y-axis.

An example of a Measure could be:

count_oh =

var tab = ADDCOLUMNS(

    SUMMARIZE (

        PSInventShortAccReportTable,

        PSInventShortAccReportTable[PsItemId],

        "Status", [StatusColumnMeasure]

    ),

    "Status1", [StatusColumnMeasure]

)

RETURN

COUNTX(FILTER(tab,[Status1] = "OH"),[Status1])

and then you can create bar chart from them as below

I hope it helps !!

Thanks and Regards,

Sayali

Please mark the question solved when done and consider giving a thumbs up if posts are helpful!! 

[Anonymous]

@sayaliredij Thanks for your reply. I have to use this status in bar chart as well, so I have to create a calumn not measure. 

[sayaliredij]

you can upload it on dropbox and share the link

[Anonymous]

@sayaliredij I have to create the conditional status column to use it bar chart and table, which will work correctly for the single and multiple prodid slicer values. 

 

[sayaliredij]

Hello @Anonymous 

Can you share your pbix file with sample data? right now I am not able to understand what is the granularity and hence can not comprehend how the formula should work

Sayali

[Anonymous]

Sure.
Thanks. @sayaliredij 

But I'm unable to attach pbix file. its giving error. "File not supported error". 

I have uploaded at drive and kindly check it. 

https://drive.google.com/drive/folders/1yGN8Qq_VXUvYQ5dsblUbXrxS_XkTDEfC?usp=sharing

Thanks