Forum Discussion
Solved
Add maximum values per column
Hi, In the case of a sale in the amount of U $ 1000.00, it was received in two times of U $ 500.00. The information is generated in the table of the SQL database, as shown: ID Sale Value ...
Hi Gelain,
have you tried with the FIRSTNONBLANK function:
Sales Value correct sum = SUMX(DISTINCT(Data[ID]), FIRSTNONBLANK(Data[Sales Value], 0))
I got the correct total:
more details:
https://stackoverflow.com/questions/43547620/sum-distinct-values-for-first-occurance-in-power-bi
Hi Gelain,
have you tried with the FIRSTNONBLANK function:
Sales Value correct sum = SUMX(DISTINCT(Data[ID]), FIRSTNONBLANK(Data[Sales Value], 0))
I got the correct total:
more details:
https://stackoverflow.com/questions/43547620/sum-distinct-values-for-first-occurance-in-power-bi
Thank you. Helped me a lot.