Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago
Solved

Values for a measure does not show up

Hi Experts!   I have three tables in PowerBI desktop.   Contract: Business, Site_ID, Contract_ID Date: DateID, Date Sales: DateID, Contract_ID, Amount   Sales account is connected to other tw...
Need Help
  • amitchandak's avatar
    amitchandak
    3 years ago

    Anonymous , try like

     

    Sumx(summarize(Sales, Contract[Business], Contract[Site ID]) , calculate(abs( TOTALMTD(SUM(Sales[Amount]),Date[DATE]))))

amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
3 years ago

Anonymous , try like

 

Sumx(summarize(Sales, Contract[Business], Contract[Site ID]) , calculate(abs( TOTALMTD(SUM(Sales[Amount]),Date[DATE]))))