Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
arusiva89
Contributor III
Contributor III

Set expression

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
1 Solution

Accepted Solutions
Lisa_P
Employee
Employee

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

Lisa_P_0-1635464211739.png

Lisa_P_2-1635464253187.pngLisa_P_1-1635464228787.png 

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

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

 

 

View solution in original post

2 Replies
Lisa_P
Employee
Employee

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

Lisa_P_0-1635464211739.png

Lisa_P_2-1635464253187.pngLisa_P_1-1635464228787.png 

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

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

 

 

arusiva89
Contributor III
Contributor III
Author

Thanks for the explanation!