Forum Discussion

idontexist's avatar
idontexist
Icon for Helper I rankHelper I
8 years ago

Calculate several numeric values

Hi guys,   I need to calculate values like the following:     Plan Fact New measure   15       15       15       15       15 15 15   15       15   ...
Need Help
v-jiascu-msft's avatar
v-jiascu-msft
Icon for Microsoft Employee rankMicrosoft Employee
8 years ago

Hi idontexist,

 

As far as I know, we can't create a measure in the mode live to SSAS cube. Did I miss something?

 

Best Regards,

Dale

idontexist's avatar
idontexist
Icon for Helper I rankHelper I
8 years ago

v-jiascu-msft

 

We can't create new columns. But new measures we can.

  • v-jiascu-msft's avatar
    v-jiascu-msft
    Icon for Microsoft Employee rankMicrosoft Employee
    8 years ago

    Hi idontexist,

     

    Hasonevalue could work. Please see the example below. What's your report like? Can you share a snapshot?

    Measure 6 =
IF (
    HASONEVALUE ( 'DimProduct'[ClassName] ),
    SUM ( FactSales[SalesQuantity] ),
    0
)

    Calculate_several_numeric_values

     

    Best Regard,

    Dale