Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
2 years ago

Status update runtime in column

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?

 

 

 

Need Help
Tips and Tricks

6 Replies

  • sayaliredij's avatar
    sayaliredij
    Solution Sage
    2 years ago

    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's avatar
    Anonymous
    Not applicable
    2 years ago

    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's avatar
    sayaliredij
    Solution Sage
    2 years ago

    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's avatar
      Anonymous
      Not applicable
      2 years ago

      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.