Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago

Summing a measure

Hi,   I have a dataset on a list of assets which will need to be replaced as time goes on. Each has a different lifecycle so they will expire at different times. The table below is a sample and con...
Need Help
v-cherch-msft's avatar
v-cherch-msft
Icon for Microsoft Employee rankMicrosoft Employee
7 years ago

Hi Anonymous

 

You may check below measure:

Measure 2 = 
VAR myTable =
    CALCULATETABLE (
        ALL ( Assets_Medical[Main_asset_number] ),
        ALLEXCEPT ( DimDate, DimDate[FiscalYearText] )
    )
RETURN
    IF (
        HASONEFILTER ( Assets_Medical[Main_asset_number] ),
        [Measure],
        SUMX ( myTable, [Measure] )
    )

Regards,

Cherie

v-cherch-msft's avatar
v-cherch-msft
Icon for Microsoft Employee rankMicrosoft Employee
7 years ago

Hi Anonymous

 

Could you tell me if your problem has been solved? If it is,kindly mark the helpful answer as a solution and welcome to share your own solution. More people will benefit from here. If not, please share more details for us so that we could help further on it.

 

Regards,

Cherie