topic Re: HELP MAKING A DAX CALCULATIONS TO GET SOME CALCULATIONS IN A MATRIX TABLE in DAX Commands and Tips

HELP MAKING A DAX CALCULATIONS TO GET SOME CALCULATIONS IN A MATRIX TABLE

Marango — Mon, 09 Sep 2024 18:29:58 GMT

Hello all,

I need to work in a report and need to get some calculates and put them in a matrix table.

I have two tables.

first table I need to make a percentage measure , I did the distinct recount to see the number of products per client but need to mesure them as the following:

the second table I need to work is making a factor between the quantities, so I need to divide the quantities only on "PRODUCCIÓN" column per client by 300.

this is how my date base looks like:

I am attaching the file so maybe it can be clearer on this link:

https://we.tl/t-VlieUo3VaO

Re: HELP MAKING A DAX CALCULATIONS TO GET SOME CALCULATIONS IN A MATRIX TABLE

powerbiexpert22 — Tue, 10 Sep 2024 04:22:28 GMT

Hi Marango ,

I managed to do so by creating seperate table using crossfilter. please see updated pbix file

https://drive.google.com/file/d/1MVmNEV2W845QLuVsl_OBgH7U75LXnVSL/view?usp=drive_link

summ_tbl =

SUMMARIZE(

CALCULATETABLE(Combinar1,FILTER(Combinar1,Combinar1[Tipo de Producto]="Protos"))

,Combinar1[Cliente],"Count",DISTINCTCOUNT(Combinar1[Codigo Producto])

)

Denom =

CALCULATE(

DISTINCTCOUNT(Combinar1[Codigo Producto]),

FILTER(Combinar1,Combinar1[Tipo de Producto]="Protos")

)

Denom1 =

IF(max(Combinar1[Tipo de Producto])<>"Protos",

CALCULATE(MAX(summ_tbl[Count]),

CROSSFILTER(Combinar1[Cliente],summ_tbl[Cliente],Both))

,[Denom])

Per% =

DIVIDE(Combinar1[No Modelos],[Denom1])

2nd Problem:

Produc =

DIVIDE(

IF(

MAX(Combinar1[Tipo de Producto])<>"Producción",0,

CALCULATE(

SUMX(Combinar1,Combinar1[Cantidad]),

FILTER(Combinar1,Combinar1[Tipo de Producto]="Producción"))),300)

Re: HELP MAKING A DAX CALCULATIONS TO GET SOME CALCULATIONS IN A MATRIX TABLE

Anonymous — Wed, 18 Sep 2024 08:02:21 GMT

Hi Marango ,

I’ve made a test for your reference:

1\For the first table , you could create a calculate table

NewTable = SUMMARIZE( Combinar1, Combinar1[Cliente], "Producción", CALCULATE(DISTINCTCOUNT(Combinar1[Codigo Producto]), Combinar1[tipo de Producto] = "Producción"), "Protos", CALCULATE(DISTINCTCOUNT(Combinar1[Codigo Producto]), Combinar1[tipo de Producto] = "Protos"), "SMS", CALCULATE(DISTINCTCOUNT(Combinar1[Codigo Producto]), Combinar1[tipo de Producto] = "SMS"), "PRODUCCION/ PROTOS",CALCULATE(DISTINCTCOUNT(Combinar1[Codigo Producto]), Combinar1[tipo de Producto] = "Producción")/CALCULATE(DISTINCTCOUNT(Combinar1[Codigo Producto]), Combinar1[tipo de Producto] = "Protos"), "SMS/ PROTOS",CALCULATE(DISTINCTCOUNT(Combinar1[Codigo Producto]), Combinar1[tipo de Producto] = "SMS")/CALCULATE(DISTINCTCOUNT(Combinar1[Codigo Producto]), Combinar1[tipo de Producto] = "Protos"), "PRODUCCIÓN /SMS",CALCULATE(DISTINCTCOUNT(Combinar1[Codigo Producto]), Combinar1[tipo de Producto] = "Producción")/ CALCULATE(DISTINCTCOUNT(Combinar1[Codigo Producto]), Combinar1[tipo de Producto] = "SMS") )

2\For the second table, you could create a calculate column for Combinar1

NewCatidad = If(Combinar1[Tipo de Producto]="Producción",Combinar1[Cantidad]/300,Combinar1[Cantidad])

Best Regards,
Bof