Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

Adding 2 measures into one measure

Hi Everyone,   I have 2 measures Actual & Projected . Actual from Table A & Projected is from Table B. Table A have data till today, Table B have values till end of the month. My requirement is ...
Need Help
  • amitchandak's avatar
    amitchandak
    5 years ago

    @Sriram_K, one way is that you put them together so you won't get line of points for the target

    Cumm ? CALCULATE(SUM(Table1[Amount]) + SUM(Table2[forecast]),filter(allselected(date),date[date] <-maxx(date,date[date])))

    O
    Cumm : CALCULATE(SUM(Table1[Amount]) + SUM(Table2[forecast]),filter(allselected(date),date[date] <-max(Sales[Sales Date])))

    another way put them as a separate measure

    Cumm AmountTM CALCULATE(SUM(Table1[Amount]) ,filter(allselected(date),date[date] <-maxx(date,date[date])))

    Cumm forecastTM CALCULATE( SUM(Table2[forecast]),filter(allselected(date),date[date] <-maxx(date,date[date])))

v-jingzhang's avatar
v-jingzhang
Icon for Community Support rankCommunity Support
5 years ago

Hi Anonymous ,

If only actual values display, it is probably because the projected values are not calculated correctly and get all the results as blank. Could you provide some sample data or .pbix file so that I can modify the measures accordingly? Please remove any sensitive information. Thanks.

Regards,

Jing

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Hi Jing,

Thanks for your response, i don't have option to attach file. can you please provide your mail ID i will share via Google drive.

My ID: [email protected]

Thanks,

Sriram.K

  • v-jingzhang's avatar
    v-jingzhang
    Icon for Community Support rankCommunity Support
    5 years ago

    Hi Anonymous 

    Sorry I cannot provide my mail ID due to some reasons. Can you save it to Google drive or other cloud platforms and share the link here that I can download directly? Please remove any confidential information in it. Thank you.

    Regards,

    Jing