Forum Discussion
Status Graph with Date Slicer
Anonymous I am thinking that you will need a disconnected table of your status codes (use an Enter Data query to enter or use:
New Table = DISTINCT('Table'[Status]). Make sure there are no relationships to this table. Use the column created in this table as your legend. Then do something like the following (below). I mocked up the solution in the attached PBIX below sig. You want Page 18.Measure 18 = VAR __Status = MAX('Table (18a)'[Status]) VAR __Table = ADDCOLUMNS( SUMMARIZE('Table (18)',[Project],"__MaxDate",MAX([Date of Status])), "__Status",MAXX(FILTER('Table (18)',[Date of Status]=[__MaxDate]),[Status]) ) RETURN COUNTROWS(FILTER(__Table,[__Status]=__Status))
Anonymous I am thinking that you will need a disconnected table of your status codes (use an Enter Data query to enter or use:
New Table = DISTINCT('Table'[Status]). Make sure there are no relationships to this table. Use the column created in this table as your legend. Then do something like the following (below). I mocked up the solution in the attached PBIX below sig. You want Page 18.
Measure 18 =
VAR __Status = MAX('Table (18a)'[Status])
VAR __Table =
ADDCOLUMNS(
SUMMARIZE('Table (18)',[Project],"__MaxDate",MAX([Date of Status])),
"__Status",MAXX(FILTER('Table (18)',[Date of Status]=[__MaxDate]),[Status])
)
RETURN
COUNTROWS(FILTER(__Table,[__Status]=__Status))
Hello Greg_Deckler , I have a follow up question. You're solution was great, and I want to add something. Besides the pie graph which shows the totals of all the projects, I also want to display a simple table which shows the names of each project, the status, and at what date it got that status. Ideally, I also want the table to be sliced based on status when you click on a piece of the pie graph.
Here is a picture of what I'm going for:
I thought of creating a column in DAX as follows. It is definetely based on what you supplied me before.