Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

unable to call the source column without using aggregate functions in measure

unable to call the source column without using aggregate functions in measure...

 

im creating measure and i dont want to use SUM or aggregate functions for MRP_AVAIL_USD_AMT column in measure...

 

 

  • amitchandak's avatar
    amitchandak
    5 years ago

    Anonymous , measure mean aggregated value, so you have to some operation like sum , min or max on MRP_AVAIL_USD_AMT 

     

    If needed you can create a new column. Only if test is not a measure

2 Replies

  • amitchandak's avatar
    amitchandak
    Icon for Super User rankSuper User
    5 years ago

    Anonymous , measure mean aggregated value, so you have to some operation like sum , min or max on MRP_AVAIL_USD_AMT 

     

    If needed you can create a new column. Only if test is not a measure

    • Anonymous's avatar
      Anonymous
      Not applicable
      5 years ago

      Yes Amit

       

      you are correct..but if i use calculated column then slicer selection filter calculations will not apply 

       

      but if i use measure then slicer selection will apply on measure only...below is the dax which im using 

       

      MRP_AVAIL_USD_AMT_SINGLE_mea =
      // var maxCol =
      // CALCULATE(MAX(AZSAT_SHPMT_INVEN_WKLY_VW[Index]), ALLEXCEPT(AZSAT_SHPMT_INVEN_WKLY_VW,AZSAT_SHPMT_INVEN_WKLY_VW[SFU_MATL_ID],AZSAT_SHPMT_INVEN_WKLY_VW[FPC_ID],AZSAT_SHPMT_INVEN_WKLY_VW[fy_mth_id]) )

      var test =

      CALCULATE(
      MAX(
      AZSAT_SHPMT_INVEN_WKLY_VW[Index]
      ),
      ALLEXCEPT(
      AZSAT_SHPMT_INVEN_WKLY_VW,
      AZSAT_SHPMT_INVEN_WKLY_VW[SFU_MATL_ID], AZSAT_SHPMT_INVEN_WKLY_VW[FPC_ID], AZSAT_SHPMT_INVEN_WKLY_VW[fy_mth_id]
      ),
      FILTERS(AZSAT_SHPMT_INVEN_WKLY_VW[BRAND_NAME]),
      FILTERS(AZSAT_SHPMT_INVEN_WKLY_VW[CUST_LVL_4_NAME]),
      FILTERS(AZSAT_SHPMT_INVEN_WKLY_VW[SUB_TRADE_CHANL_NAME]),
      FILTERS(AZSAT_SHPMT_INVEN_WKLY_VW[ATTR_1_NAME]),
      FILTERS(AZSAT_SHPMT_INVEN_WKLY_VW[ATTR_2_NAME]),
      FILTERS(AZSAT_SHPMT_INVEN_WKLY_VW[ATTR_3_NAME]),
      FILTERS(AZSAT_SHPMT_INVEN_WKLY_VW[ATTR_4_NAME]),
      FILTERS(AZSAT_SHPMT_INVEN_WKLY_VW[ATTR_5_NAME]),
      FILTERS(AZSAT_SHPMT_INVEN_WKLY_VW[ATTR_6_NAME]),
      FILTERS(AZSAT_SHPMT_INVEN_WKLY_VW[ATTR_7_NAME]),
      FILTERS(AZSAT_SHPMT_INVEN_WKLY_VW[ATTR_8_NAME]),
      FILTERS(AZSAT_SHPMT_INVEN_WKLY_VW[PROFT_CTR_LVL_5_NAME]),
      FILTERS(AZSAT_SHPMT_INVEN_WKLY_VW[LOCAL_DFU_STTUS_NAME]),
      FILTERS(AZSAT_SHPMT_INVEN_WKLY_VW[LOCAL_MATL_STTUS_NAME]),
      FILTERS(AZSAT_SHPMT_INVEN_WKLY_VW[CATEG_NAME]),
      FILTERS(AZSAT_SHPMT_INVEN_WKLY_VW[CSU_IND])
      ,FILTERS(AZSAT_SHPMT_INVEN_WKLY_VW[Geolevel_sl]),

      FILTERS('distinct subsector'[Subsector]),

      FILTERS(AZSAT_SHPMT_INVEN_WKLY_VW[SelectedMarket])
      )

      return if(test= MAX(AZSAT_SHPMT_INVEN_WKLY_VW[Index]),SUM(AZSAT_SHPMT_INVEN_WKLY_VW[MRP_AVAIL_USD_AMT]))