Forum Discussion

idontexist's avatar
idontexist
Helper 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
Microsoft Employee
8 years ago

Hi idontexist,

 

Can you share the pbix file please? The relationship between two tables could affect the result.

 

Best Regards,

Dale

idontexist's avatar
idontexist
Helper I
8 years ago

Hi, v-jiascu-msft

 

i can do that, but you will not be able to see anything, as it's connected to live cube. And i don't have rights to grant you access.

  • v-jiascu-msft's avatar
    v-jiascu-msft
    Microsoft 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
      Helper 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
        Microsoft 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