Filtral con power pivot en tabla dinámica

Tengo una tabla creada con power pivot y en ella hay medidas; me gustaría si me podéis ayudar a filtrar una de las medidas cuyo resultado en -1

1 Respuesta

Respuesta

I. Hola Corched, aunque no soy conocedor creo que podría lograr lo que desea mediante la función "Calculate" como explican en ester video tutorial.

https://www.youtube.com/watch?v=Js67EGU4jIY 

https://macrordinary-ca.translate.goog/2019/12/09/filter-and-calculate-removing-pre-calculated-totals/?_x_tr_sl=en&_x_tr_tl=es&_x_tr_hl=es&_x_tr_pto=sc 


Si fuese necesario podría ponerle en contacto con varios expertos que sí podrán atenderle, pero deseaba dejarle la escasa información que vi con la esperanza de que si dispusiera de tiempo pudiese serle de alguna utilidad.

Le ruego me disculpe por todas las molestias de lectura y la imprecisión. Ánimo.


https://stackoverflow.com/questions/55749282/filter-a-measure-in-power-pivot 

https://www-mrexcel-com.translate.goog/board/threads/how-can-i-filter-a-powerpivot-table-based-on-a-calculated-measure.664987/?_x_tr_sl=en&_x_tr_tl=es&_x_tr_hl=es&_x_tr_pto=sc 

https://sumproduct-com.translate.goog/blog/power-pivot-principles-how-to-combine-three-or-more-filter-criteria-into-one-calculate-measure/?_x_tr_sl=en&_x_tr_tl=es&_x_tr_hl=es&_x_tr_pto=sc 

https://www-wiseowl-co-uk.translate.goog/power-pivot/exercises/power-pivot/filter-function/5332/?_x_tr_sl=en&_x_tr_tl=es&_x_tr_hl=es&_x_tr_pto=sc 

https://www-wiseowl-co-uk.translate.goog/power-pivot/exercises/power-pivot/filter-function/5333/?_x_tr_sl=en&_x_tr_tl=es&_x_tr_hl=es&_x_tr_pto=sc 

https://www.mrexcel.com/board/threads/filter-power-pivot-by-the-result-of-a-measure.1253585/ 

https://stackoverflow.com/questions/31198383/excel-slicers-for-measures 

https://endjin-com.translate.goog/blog/measures-vs-calculated-columns-in-dax?_x_tr_sl=en&_x_tr_tl=es&_x_tr_hl=es&_x_tr_pto=sc 

https://www-icaew-com.translate.goog/technical/technology/excel-community/excel-community-articles/2021/excel-tip-of-the-week-388?_x_tr_sl=en&_x_tr_tl=es&_x_tr_hl=es&_x_tr_pto=sc 

https://www-wiseowl-co-uk.translate.goog/power-pivot/exercises/power-pivot/filter-function/5331/?_x_tr_sl=en&_x_tr_tl=es&_x_tr_hl=es&_x_tr_pto=sc 

https://www.mrexcel.com/board/threads/how-can-i-filter-a-powerpivot-table-based-on-a-calculated-measure.664987/ 

https://www.youtube.com/watch?v=0T4_AUkPa3k 

https://www-myonlinetraininghub-com.translate.goog/excel-forum/power-pivot/add-a-remark-as-a-measure-to-filter-the-powerpivot-table?_x_tr_sl=en&_x_tr_tl=es&_x_tr_hl=es&_x_tr_pto=sc 

https://exceleratorbi-com-au.translate.goog/killer-tips-write-harder-measures/?_x_tr_sl=en&_x_tr_tl=es&_x_tr_hl=es&_x_tr_pto=sc 

https://www.youtube.com/watch?v=AZAL-QPn5Zc 

https://stackoverflow.com/questions/58539269/powerbi-dax-using-a-measure-as-a-filter-within-a-calculate-function 

https://www.reddit.com/r/excel/comments/55ahxc/powerpivot_filtering_a_measure/ 

https://www.youtube.com/watch?v=75ud4B5w5Aw 

https://ayudaexcel.com/foro/index.php?/topic/22919-hacer-busqueda-en-un-libro-y-copiar-filas-no-vac%C3%ADas-a-partir-de-esa-en-otro-libro/ 

https://www.reddit.com/r/excel/comments/14jy2r7/filtering_power_pivot_columns_with_different/?tl=es-419 

https://www.reddit.com/r/excel/comments/16awhm9/advanced_filter_pivot_table/?tl=es-es 

https://datasavvy-me.translate.goog/2014/01/20/moving-calculated-measures-in-power-pivot-for-excel-2013/?_x_tr_sl=en&_x_tr_tl=es&_x_tr_hl=es&_x_tr_pto=sc 

https://amby.net/2015/03/19/power-query-vs-power-pivot-filtros-avanzados-en-tabla-dinamica/ 

https://esvanguardia.cl/propagacion-de-filtros-en-power-pivot-power-bi/ 

https://es.linkedin.com/learning/excel-2019-power-pivot/como-filtrar-y-ordenar-en-power-pivot-en-excel-2019 

https://www.facebook.com/groups/PowerQuery/posts/25697283279862806/ 

Añade tu respuesta

Haz clic para o

Más respuestas relacionadas