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,

 

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