Status update runtime in column

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!!