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

v-juanli-msft's avatar
v-juanli-msft
Icon for Community Support rankCommunity Support
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