Ormondo_99
New Member
- Joined
- Jan 16, 2013
- Messages
- 7
Hi,
I have another query regarding Powerpivot. I have two tables.
1. called GFS which holds ticket information, such as logged, and resolved date data including summary information etc in separate fields.
2. I have a "historical data" table which holds the same information as the "GFS" table but can have multiple rows of the same tickets as it shows what state the ticket was in on different days of the month.
Hi,
I have another query regarding Powerpivot. I have two tables.
1. called GFS which holds ticket information, such as logged, and resolved date data including summary information etc in separate fields.
2. I have a "historical data" table which holds the same information as the "GFS" table but can have multiple rows of the same tickets as it shows what state the ticket was in on different days of the month.
I also have a date table set-up for both.
When I create a chart for "logged and Resolved" on the GFS data it works fine as I have the below measures in place:
- LoggedCount:=COUNTA(GFS[Logged])
- ResolvedCount:=COUNTA(GFS[ResolvedDate])
- Actual Logged:=CALCULATE([LoggedCount],USERELATIONSHIP(Calendar[DateKey],GFS[Logged]))
-Actual Resolved:=CALCULATE([ResolvedCount],USERELATIONSHIP(Calendar[DateKey],GFS[ResolvedDate]))
However, when I create the same chart for the "Historical data" with similar measures i get different results and this is because the dates are not unique because there are multiple rows for the same ticket ref.
How do I get the historical data measures to discount multiple rows of the same reference?
I also have a date table set-up for both.
When I create a chart for "logged and Resolved" on the GFS data it works fine as I have the below measures in place.
However, when I create the same chart for the "Historical data" with similar measures I get different results and this is because the dates are not unique because there are multiple rows for the same ticket ref.
How do I get the historical data measures to discount multiple rows of the same reference?
I have another query regarding Powerpivot. I have two tables.
1. called GFS which holds ticket information, such as logged, and resolved date data including summary information etc in separate fields.
2. I have a "historical data" table which holds the same information as the "GFS" table but can have multiple rows of the same tickets as it shows what state the ticket was in on different days of the month.
Hi,
I have another query regarding Powerpivot. I have two tables.
1. called GFS which holds ticket information, such as logged, and resolved date data including summary information etc in separate fields.
2. I have a "historical data" table which holds the same information as the "GFS" table but can have multiple rows of the same tickets as it shows what state the ticket was in on different days of the month.
I also have a date table set-up for both.
When I create a chart for "logged and Resolved" on the GFS data it works fine as I have the below measures in place:
- LoggedCount:=COUNTA(GFS[Logged])
- ResolvedCount:=COUNTA(GFS[ResolvedDate])
- Actual Logged:=CALCULATE([LoggedCount],USERELATIONSHIP(Calendar[DateKey],GFS[Logged]))
-Actual Resolved:=CALCULATE([ResolvedCount],USERELATIONSHIP(Calendar[DateKey],GFS[ResolvedDate]))
However, when I create the same chart for the "Historical data" with similar measures i get different results and this is because the dates are not unique because there are multiple rows for the same ticket ref.
How do I get the historical data measures to discount multiple rows of the same reference?
I also have a date table set-up for both.
When I create a chart for "logged and Resolved" on the GFS data it works fine as I have the below measures in place.
However, when I create the same chart for the "Historical data" with similar measures I get different results and this is because the dates are not unique because there are multiple rows for the same ticket ref.
How do I get the historical data measures to discount multiple rows of the same reference?
