This content has been marked as final. Show 4 replies
I have data that is pulled into one table with QuoteID and Amount field. I am writing an expression for measure where I want to divide the Amount by the number of counts in QuoteID and then sum all the Amounts in the table. Below is what I put in the syntax but seems like there is error in expression. The data has QuoteID and amount associated to each QuoteID. QuoteID is unique to most records but some QuoteID occur more than once and hence the Amount is multiplied by the number of times QuoteID apprears hence I want to divide the Amount by the Distinct(QuoteID) and then sum all the Amounts in the table in visualization. Can someone please help?