Forum Discussion

Grahamwest's avatar
Grahamwest
Regular Visitor
9 years ago

Need help with formula

Hello Folks,   I got an example table with:     Batch                           Qty (Kg)          Auction no. A1025                           5                                1 A1025          ...
Grahamwest's avatar
Grahamwest
Regular Visitor
9 years ago

Can it be done by using measure?

 

I have almost reached at the end, but now the porblem is totals. See this:

 

I tried doing it mathematically:

 

-TotalOfferedforunique = DIVIDE(SUM('Live Auction'[Offered QTY]),COUNT('Live Auction'[Batch No]))

-Distict Batch Count = DISTINCTCOUNT('Live Auction'[Batch No])

-Unique Offered QTY (MT) = [TotalOfferedforunique]*[Distict Batch Count]

 

Now the same formula is getting applied on its total, which I dont want. I want the sum of the columns.

 

When I am exporting it in excel and adding up it is giving me the unique value but not when I am seeing it in BI.

 

Thanks,

Graham