Forum Discussion

subguts's avatar
subguts
Regular Visitor
3 years ago

Need help with a measure

Hi, I have a table as shown below.   The StatusEnd column equals different statuses, In Progress, Submitted, etc. The RequestID is the unique ID for a request and therefore can appear multiple tim...
Need Help
Bhu1singh's avatar
Bhu1singh
Frequent Visitor
3 years ago

Hi,

Create a calculated column sometime like this:

LatestStatus =
CALCULATE (
MAX ( <table name>[StatusEnd] ),
ALLEXCEPT ( <table name>, <table name>[RequestID] ),
<table name>[Modified] = <table name>[Modified]
)

note: we can also write a measure in same way.
 
Thanks
Bhuvan
  • subguts's avatar
    subguts
    Regular Visitor
    3 years ago

    Does this require 2 different tables?
    Also, if I use the same table every where it says <table name> it doesn't cause an error, but doesn't enable me to get the infomration I want, which is the the number of RequestIDs that have a certain StatusEnd.  So it's the count of all RequestIDs with let's say StatusEnd ="Submitted".  However, you have to look for the last modified record in the table since each Request can be in a different status at some point.  So again, the intent is to get the current status for each request and give a total of how many requests at the time the dashboard is diplayed are in each of the statuses that can be in the Status End field.

     

    Hope this makes sense and understand this may be difficult to understand/answer via this forum.

     

    Thank you