Agrupar kpis en función de la seleccion de usuario

[IsaTMK]

Hola, me gustaría mostrar los kpis agrupados por una categoría, en funciom de lo que elija el usuario final. 

Si. Quiere ver la info por edad, o por sexo o por país.

Que esto (edad. Sexo o pais) sea un filtro y según la selección del user laninf. Se muestre en una tabla agrupada por los valores de la categoria seleccionada. 

[v-easonf-msft]

Hi , @IsaTMK 

You may check if this thread helps.

https://community.powerbi.com/t5/Desktop/Grouping-dates-and-KPIs-by-category/m-p/1072232

If it doesn't meet your requierment,please share more details.

Best Regards,
Community Support Team _ Eason

[IsaTMK]

Hola,

No no me sirve este  hilo, he adjuntado mas detalle, espero me puedan ayudar

[IsaTMK]

Hello

Yes, I'm sorry.

I compare an example image, the purpose is to be able to display the info. in the "dimension" row, by any of the dimensions of the button above shown (Year, Campaign, Channel, Date,Month,Supplier)

As the user, select why you want to view the info. the table must change its row value to the one selected in the button.

I don't want to use the following two options:

• bookmark
• No joined queries (it's how I now work but it replicates me a lot of info. without needing to be)

[PaulDBrown]

@IsaTMK 

Why don't you want to use bookmarks?

One way of doing this is to set up a table with the values you want to use in the slicer. You then have to write measures using the SWITCH function to return the calculations based on the SELECTEDVALUE on the "Slicer".

It does however seem potentially laborious if compared to using bookmarks.

[IsaTMK]

Hello

When you use a lot of groupings, I find it complex to maintain. I'm data and I'd rather handle everything in it.

The option you expose to me only serves to change metrics, this is not calculations, only change the value of the field to group and with the selectvalue I have not been able to solve it

[PaulDBrown]

@IsaTMK
I'm not following you. You'll have to change metrics based on the selection in the Slicer. What do you mean when you say they're not calculations?

[IsaTMK]

Metrics are fixed, they're always the same.

The only thing I change is which field/column I want to show those grouped metrics.

[PaulDBrown]

@IsaTMK

If the values in the slicer are one-column, and are related to the data tables, they will function as a filter directly. If they are not columns, or you relate to the data table, or you have to indicate what should be calculated with the selection as I have suggested.
Do you have a dummy example of PBIX data/file?

[IsaTMK]

Hello

I make it clear, the report I already have it painted as it should be but I know that it is not the most efficient way since I use union and replicate data.

Imagine that I have this view, and in the pbxi I want to show the sum of the two metrics, but grouped by name or age, as the end user chooses me. ( without using bookmark, this in a ridiculous example, in the real I have up to 20 columns by which to give the user to see the grouped information)

I hope I've explained myself

[PaulDBrown]

@IsaTMK

Look at this example:

[IsaTMK]

Simple example,

I want to choose to group metrica1 by Name or by Age in the table, as you choose in the filter,

The calculation I'm applying in "Column" always goes down the else..

[PaulDBrown]

@IsaTMK

In the example you set, the result of the evaluation of the SWITCH function is a column; has to be a measure or fixed value. Cannot be a list (of a column).

Let's see if this helps:

[IsaTMK]

I'm sorry, but I don't quite understand your example.

The final table should always have metrica1 and metric 2 (in your example) and the column by which to group is the age or name value.

I do not understand very well the end of your example, you can do it by choosing "Name", in type selection and the final table has three columns, the two metrics and the "field" type selection?

[PaulDBrown]

@IsaTMK

I don't know how to make row values from different columns dynamic only by using DAX.
This can be done by creating a table that includes:
1) The values you're going to use as a Slicer ("Selección" in my example below)

2) All unique values associated with that selection value (1) ("Valor" in my example below)
This is relatively easy to do in Power Query
For example:

You then create measures that act on the selection in the Slicer, and that group based on the values that top the table or matrix.

The model I have looks like this:

The data table:
I create the report using the "Selection" table as Slicer, and in the rows of the table I put the field "Selection[Value] (from the same table) that I use as a slicer.

Metrics I use the TREATAS function to associate the column in the data table with the values selected in the Slicer:

Metrica 1 = 
VAR SumaNombre = CALCULATE([Suma Metrica 1], TREATAS(VALUES(Seleccion[Valor]), Tabla1[Nombre]))
VAR SumaEdad = CALCULATE([Suma Metrica 1], TREATAS(VALUES(Seleccion[Valor]), Tabla1[Edad]))
VAR SumaDepartamento = CALCULATE([Suma Metrica 1], TREATAS(VALUES(Seleccion[Valor]), Tabla1[Departamento]))
VAR SumaCiudad = CALCULATE([Suma Metrica 1], TREATAS(VALUES(Seleccion[Valor]), Tabla1[Ciudad]))
RETURN
SWITCH(TRUE(),
SELECTEDVALUE(Seleccion[Seleccción]) = "Nombre", SumaNombre,
SELECTEDVALUE(Seleccion[Seleccción]) = "Edad", SumaEdad,
SELECTEDVALUE(Seleccion[Seleccción]) = "Departamento", SumaDepartamento,
SumaCiudad)

And with this the selection of values in the table/matrix become dynamic:

I don't know any other way.

Tell me if the PBIX file is good for uploading.

[IsaTMK]

Hello

I evoke it and I tell you

Thanks a lot

[v-easonf-msft]

Hi , @IsaTMK 

Could you please tell me whether your problem has been solved?
If it is,  please mark the helpful replies or add your reply as Answered to close this thread.
It will help other community members easily find the solution when they get the similar issue.

Best Regards,
Community Support Team _ Eason

[IsaTMK]

Hello, good morning

Finally, I was able to fix it in a super fast way.

Using the Power Bi Unpivot option. In this one you can choose which fields you want to dynaminte and be able to play with them in a filter.

[PaulDBrown]

@IsaTMK 

OK. Let us know how it goes (and if you need the sample PBIX file)

[IsaTMK]

@PaulDBrown hope I have explained myself in that example, thank you!

[IsaTMK]

Hi Paul,

Thank you, what you show in the example is a metric field that changes the metric to be displayed, but not the vble by which you group that metric which is what I really need.