Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
miguelHG
Frequent Visitor

Crear medidas por características de articulo

Buen Día a Todos,

Espero me puedan ayudar con este tema que no he podido resolver, sobra decir que apenas estoy aprendiendo a usar power bi, pero en este caso no he encontrado una solución 100% correcta. Tengo una tabla de artículos y cada uno de los items tiene más de 50 caracteristicas que están en columnas, carct1, caract2, etc, pero necesito sacar la venta según las caracteristicas, ya que en unos articulos, la caract9 es "llanta", carcact25 es "SUB", entonces, me piden la venta de todas las llantas, (caract9) y de ahí, un sub arbol para poder ver unicamnete las de SUB, espero haberme explciado, Gracias.

2 REPLIES 2
miguelHG
Frequent Visitor

Thanks @amitchandak, it is a complicated subject, that's why I ask for your support, I have tried

"IF (HASONEVALUE ('Table' [ ]), SWITCH (VALUES ()"

, but I thought there should be a simpler way, with DAX. The table that contains this information is that of items, but I have others that contain all the sales and inventory operations, etc., I don't know if it is feasible to unpivot that table.

amitchandak
Super User
Super User

@miguelHG , Not able to get it completely. What I got is; say the tire is characteristic 9 for one item and can be characteristic 25 for another. If this is the case you need data normalization. Means you put the same character in the same column.  That could be a lot of work and need a lot if-else or switch.

 

Another way is you unpivot all these columns, so you will only one characteristic column. But this means 50-times data and you need to handle formula's not to duplicate the count and sums.

 

https://radacad.com/pivot-and-unpivot-with-power-bi
https://www.youtube.com/watch?v=2HjkBtxSM0g

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors