Forum Discussion

kalif's avatar
kalif
Icon for Helper I rankHelper I
7 years ago
Solved

How to create measure count the Con_num while selected Month

Find below table & below measure using Average & Count, But While select the Month in Filter below measure is not refreshed     AVERAGE = SUM(VDASUM1[VDA AMOUNT]) / COUNT(VDASUM1[AID_CON_NUM]) an...
Need Help
  • v-juanli-msft's avatar
    v-juanli-msft
    7 years ago

    Hi kalif

    When i test with your dataset, i can make the month slicer work for my measure.

    1. add "month" in the slicer

     

    2. create a calendar date table and connect it to your table, then add year and month from the calendar date table to the slicer,

     

    Measures

    sum = SUM(Sheet2[VDA AMOUNT])

count = COUNT(Sheet2[CON_NUM])

average = [sum]/[count]

average2 = AVERAGE(Sheet2[VDA AMOUNT])

     

    If you have any problem please let me know

     

     

    Best Regards

    Maggie

Greg_Deckler's avatar
Greg_Deckler
Icon for Community Champion rankCommunity Champion
7 years ago

Why not just use:

 

AVERAGE = AVERAGE(Table9[VDA AMOUNT])

See attached PBIX and you want Table9, Page 4

kalif's avatar
kalif
Icon for Helper I rankHelper I
7 years ago

Thanks Mr. Greg_Deckler, Below measure working fine, but am using Table SUMMARIZE from another table, filers set from mother table, find below for mother Table format

 

MONTHGROUPCHG_CODEVDA AMOUNTBKG_NUMCON_NUMVDA NUM
November-18CCUWASH9.75SHLPK18001152AMFU3221483AGIN1819000129HQ
November-18CCUSUR9.75SHLPK18001152AMFU3221483AGIN1819000129HQ
November-18CCUSOR0SHLPK18001152AMFU3221483AGIN1819000129HQ
November-18CCULAS0.05SHLPK18001152AMFU3221483AGIN1819000129HQ
November-18CCUISPS3.25SHLPK18001152AMFU3221483AGIN1819000129HQ
November-18CCUICOM-10SHLPK18001152AMFU3221483AGIN1819000129HQ
November-18CCUFRT300SHLPK18001152AMFU3221483AGIN1819000129HQ
November-18CCUEQP26SHLPK18001152AMFU3221483AGIN1819000129HQ

 

How can get measure for this case