Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
8 years ago
Solved

Running 12 month Total with Condition

Hi,   I want to create a measure to calculate "Total shipment count for running 12 months". But the condition is if there are multiple shipment(i.e. >1) in same Month&Year(eg. for December 2017 the...
Need Help
  • v-juanli-msft's avatar
    v-juanli-msft
    8 years ago

    Hi Anonymous

    As tested, when i add a measure in the SUMX function, it shows the same value as yours.

    Measure 3 = SUMX(DISTINCT(Table2),[Measure])

     

    Here is my pbix

     

Anonymous's avatar
Anonymous
Not applicable
8 years ago

Hi Maggie,

 

Thanks for your reply.

Actually I tried creating the measures as you told but its still giving same output in Measure 2. I am not getting if I am going wrong somewhere :-(

 

Please find the screenshot below,

v-juanli-msft's avatar
v-juanli-msft
Icon for Community Support rankCommunity Support
8 years ago

Hi Anonymous

As tested, when i add a measure in the SUMX function, it shows the same value as yours.

Measure 3 = SUMX(DISTINCT(Table2),[Measure])

 

Here is my pbix