Hi,
When i created the following measures, i expected both the values to be same but they are different.
Can anyone help me understand why that is the case.?
Measure 1 =
CALCULATE (
COUNT ( 'Benchmark Group Base data'[Group Ticket days grouping] ),
'Benchmark Group Base data'[benchmarkgroup] = "Government",
TREATAS (
VALUES ( 'Benchmark Base Data'[Ticket days grouping] ),
'Benchmark Group Base data'[Group Ticket days grouping]
),
TREATAS (
VALUES ( 'Benchmark Base Data'[International or Domestic] ),
'Benchmark Group Base data'[International or Domestic]
),
TREATAS (
VALUES ( 'Benchmark Base Data'[flight_departure_datetime] ),
'Benchmark Group Base data'[flight_departure_datetime]
)
)
And the value is 13307
Measure 2 =
CALCULATE (
COUNT ( 'Benchmark Group Base data'[dim_price_item_key] ),
'Benchmark Group Base data'[benchmarkgroup] = "Government",
TREATAS (
SUMMARIZE (
'Benchmark Base Data',
'Benchmark Base Data'[Ticket days grouping],
'Benchmark Base Data'[flight_departure_datetime],
'Benchmark Base Data'[International or Domestic]
),
'Benchmark Group Base data'[Group Ticket days grouping],
'Benchmark Group Base data'[flight_departure_datetime],
'Benchmark Group Base data'[International or Domestic]
)
)
and the value is 5871
Tagging people who helped in the past. @parry2k
