Forum Discussion

jdballard30's avatar
jdballard30
Icon for Helper II rankHelper II
7 years ago
Solved

Trouble Creating (what I think should be a) Simple Measure

I have two tables in my source data (there's more, but those are the pertinent ones), Application and Transactions. An application can have one or many transactions. I have denormalized them into one...
Need Help
  • Ashish_Mathur's avatar
    Ashish_Mathur
    7 years ago

    Hi,

     

    Try these measures

     

    Measure1=SUMX(SUMMARIZE(VALUES(Data[ApplicationID]),[ApplicationID],"ABCD",MIN(Data[EstimatedAmount])),[ABCD])

    Measure2=[Measure1]/DISTINCTCOUNT(Data[ApplicationID])

     

    Hope this helps.

Ashish_Mathur's avatar
Ashish_Mathur
Icon for Super User rankSuper User
7 years ago

Hi,

 

Try these measures

 

Measure1=SUMX(SUMMARIZE(VALUES(Data[ApplicationID]),[ApplicationID],"ABCD",MIN(Data[EstimatedAmount])),[ABCD])

Measure2=[Measure1]/DISTINCTCOUNT(Data[ApplicationID])

 

Hope this helps.