Set expression

[arusiva89]

I need to calculate the sum of Revenue which has Datatype in $ (Expected result is 140 for below table).Is that possible to get it through set expression

Region	Type	Measure
R1	Revenue	100
R1	DataType	$
R2	Revenue	30
R2	DataType	%
R3	Revenue	40
R3	DataType	$
R4	Revenue	10
R4	DataType	D

[Lisa_P · Accepted solution]

You can load the data using a Generic load (put Generic before load statement) and you will get 2 tables in the data model.

 

This will allow you to calculate the Sum(Revenue) where DataType is $ using set analysis

Sum({<DataType={$}>}Revenue)

[arusiva89]

Thanks for the explanation!