Forum Discussion
Challenge with my data in Column Chart
Microsoft EmployeePlease try these measure expressions in a visual with the Date column.
Open = SUMX(FILTER(Table, Table[Opened]<>Table[Closed]), Table[Opened])
Closed = SUMX(FILTER(Table, Table[Opened]<>Table[Closed]), Table[Closed])
If this works for you, please mark it as the solution. Kudos are appreciated too. Please let me know if not.
Regards,
Pat
The result was that it excluded all cases where Open and Closed was equal to 1, but I need them included.
I changed the filter to Table[Closed]=Table[Closed] and that worked, but seems like an odd filter. Should I do that a different way?
First time I've used a Measure, so new terratory for me. I appreciate your ideas.
And, I'm not sure how this helps me. I basically end up with the same thing I have. Two columns expressing Opened and Closed. I don't know how to then chart that into a Clustered Column Chart, showing a Column with the Opened total and a column with the Closed total, for each date.
- Ashish_Mathur
Super User
Yes, that's the type of chart I want. My problem is that my data is not as nice as the data in your example. On a single row I can have both Opened and Closed. It's like I need a way to dynamically split that row into two, an Opened row and a Closed row. I'm not controlling the data that comes in, or I'd just change it at it's source.
ID Date Opened Closed Attribute 1 1-Jan 1 0 Opened 1 1-Feb 0 1 Closed 2 1-Jan 1 0 Opened 2 1-Feb 0 1 Closed 3 1-Jan 1 1 Both 4 1-Jan 1 0 Opened 4 1-Feb 0 1 Closed
