Ben_Kronk Tracker

Re: Dynamic numerator based on slicer selections

Ben_Kronk — Mon, 15 Mar 2021 17:59:35 GMT

Thank you!

Dynamic numerator based on slicer selections

Ben_Kronk — Fri, 12 Mar 2021 20:44:45 GMT

I have a requirement for a Power BI dashboard and I'm not sure how to approach it, or if it's possible.

I need a calculation where the numerator is dynamic based on the slicer selection, but the denominator is static for each selection. The output should be a bar chart with the bars representing the percentages for each line item/category based on the slicer selection.

For example, let's say I need the percentage of Accounts Receivable in the Midwest and South Regions relative to the whole
company, so the selection of the Midwest plus the South (which is the numerator) divided by all Regions' Accounts Receivable (denominator) gives me X%.

In other case, maybe I want the percentage of just the Midwest Region for Accounts Receivable, so the bar chart would update to show the percentage of just the Midwest Accounts Receivable (numerator) divided by all Regions Accounts Receivable (denominator).

I have 30 line items that this would need to work for and each line should update based on the Region selection, whether choosing one region or more than one.

The basic question is: Can I use the selection from a slicer to make a measure with a dynamic numerator but a static
denominator based on a unique line item/category? And if it's not possible to do this specifically, is there another potential solution?

Re: Crear una columna media filtrada combinando dos medidas

Ben_Kronk — Mon, 23 Mar 2020 13:13:23 GMT

Está bien, lo tengo. Mi último paso es tomar la medida promedio (.59) y hacer que ese número se repita en su propia columna.

Ex.

.88 .59

.47 .59

.24 .59

etcetera.

Mi objetivo es crear un gráfico de doble eje con barras de diferentes alturas para cada valor, y una línea consistente en todo el gráfico - puedo crear este gráfico por mi cuenta.

Re: Create a filtered average column by combining two measures

Ben_Kronk — Mon, 23 Mar 2020 13:13:13 GMT

Okay got it. My final step is take the average measure (.59) and make that number repeat in its own column.

Ex.

.88 .59

.47 .59

.24 .59

Etc.

My goal is to create a dual axis chart with bars of different heights for each value, and a consistent line across the entire chart - I can create this chart on my own.

Crear una columna media filtrada combinando dos medidas

Ben_Kronk — Mon, 23 Mar 2020 12:14:57 GMT

Soy nuevo en Power BI y quiero crear una nueva columna que un promedio del total de otras dos columnas.

Puedo crear el total usando una medida: TOTAL 1 - DISTINCTCOUNT(Base de datos[Columna 1])

También puedo crear el otro total: TOTAL 2 - SUM(Base de datos[Columna 2])

Quiero dividir el total de TOTAL 2 por TOTAL 1. Pero cuando hago esto, obtengo el promedio de toda la base de datos. Quiero el promedio de sólo la tabla y / o visual que creé usando filtros.

Create a filtered average column by combining two measures

Ben_Kronk — Mon, 23 Mar 2020 12:14:46 GMT

I am new to Power BI and I want to create a new column that an average of the total of two other columns.

I can create the total using a measure: TOTAL 1 = DISTINCTCOUNT(Database[Column 1])

I can also create the other total: TOTAL 2 = SUM(Database[Column 2])

I want to divide the total of TOTAL 2 by TOTAL 1. But when I do this, I get the average of the entire database. I want the average of just the table and/or visual that I created using filters.