Difference between both the ways of using TREATAS

[Anonymous]

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  

[dax]

Hi anushavikram,

I can't reproduce your design just based on your expression and description, so if possible, could you please inform me more detailed information(such as your sample data and your expected output)? Then I will help you more correctly.

Best Regards,
Zoe Zhi

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.