topic Re: Incorrect table sum in DAX Commands and Tips

Incorrect table sum

Syndicate_Admin — Mon, 17 Jun 2024 10:07:07 GMT

Good.

I have a table in which I calculate a cost, this comes from the measurement

Cost = (TOTAL/TOTAL_MES) * TOTAL_UNIDAD

Total month and unit are from the same table, the total is not.

In the following image I want to calculate the sum of the green, since the total shows me some values that lead me to error, the table is applied the date and unit filter that makes total unit vary.

I really work with 6 units but I have put that the ones with total unity to zero do not appear, it would really be like this:

Any ideas to show on a card only the sum of the values in the cost column.

Thanks a lot

Re: Incorrect table sum

Anonymous — Tue, 18 Jun 2024 01:51:54 GMT

Hi Syndicate_Admin ,

You can modify your meaure like below:

Result = CALCULATE( SUMX( 'Table' , ( 'Table'[TOTAL] / 'Table'[TOTAL_MES]) * 'Table'[TOTAL_UNIDAD] ), ALLSELECTED('Table'[Date]), ALLSELECTED('Table'[Unit]) )

How to Get Your Question Answered Quickly - Microsoft Fabric Community

If it does not help, please provide more details with your desired out put and pbix file without privacy information.

Best Regards,

Ada Wang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Re: Incorrect table sum

Aguirre — Tue, 18 Jun 2024 06:55:37 GMT

Good.

I have tried the measurement and it does not work correctly for me as you can see in the picture:

I detail in the image the adapted measure and the other disaggregated measures, I am going to try to set up an example in .pbix,

COSTE_FORO =

CALCULATE(

SUMX(

'F_BI_REPARTO' ,

( [TOTAL] / [TOTAL_MES]) * F_BI_REPARTO[TOTAL_UNIDAD]

ALLSELECTED(Calendar[Date]),

ALLSELECTED(F_BI_FARMACIA_REPARTO_HOSP[UNIT])

)

TOTAL_MES=

CALCULATE(

SUM( F_BI_REPARTO[TOTAL_UNIDAD]),

REMOVEFILTERS(F_BI_REPARTO[UNIT])

)

TOTAL = SUMX(

F_BI_GESTION,

F_BI_GESTION[Cantidad_Signo]*F_BI_GESTION[PRECIO_MEDIO]

)