Division Measure Total in a table incorrect

[Anonymous]

Hi, 

I have a simple DAX which divides one column from another. 

Quote Term 2 = SUM('Case'[OppJoinHead.Quotes.Term__c]) / Count('Case'[Id])

My issue is that the Quote Term 2 Total is showing the measure of the total (64.92) where i need it to show the total value of the column (635.03). I have looked at previous posts and some videos on YT but only found solutions for Multiplications not division. 

Any help is appriciated. 

Dobby Libr3

[Anonymous]

Hi Dobby - 

Do you mind sharing the file (you can send it in a private message to me). I tried to replicate your situation but was unable to do so.

Regards

E

[Anonymous]

Hello, I have made a sample PBix , This is pretty much the same I just changed the COUNT in the DAX to a SUM.

Thanks E

[v-kelly-msft · Accepted solution]

Hi @Anonymous ，

Why not create a calculated column instead of measure?

Expression is as below:

Column = 'Table'[Quote - Term]/'Table'[Count]

And you will see:

Here, measure is applied in row,while calculated column is in context.

Best Regards,
Kelly

[Anonymous]

Hi Dobby - 

Please create a new measure as explained below . If it works please let me know, I will be able to explain what's happening here.

Quote Term 3 = IF(HASONEFILTER('Table'[Index]),SUM('Table'[Quote - Term]) / COUNT('Table'[Count]),SUMX('Table',([Quote Term 2])))

Once the above is added, please add the above measure in the table visual and that should help get what you were looking for. Please let me know.

Regards

E