Calculated Column/Table Change Dynamically According to Slicer Selection in the Report.

[arossello]

Hello everyone,

This is my first message in the forum, I have a problem that we know how to solve, I have a table with people who have been in a hotel detailed by room type as well as the date of the reservation. I need to know how many people I have today, by months and type of room, there is no problem, but when I try to know how I was on the same day of the year I can only get the total and I do not get the data by room type.

Below I detail the measures used:

Measure Estancias 

Estancias = SUM(f_valoracion[personas])

Measure Estancias LY

Estancias LY = CALCULATE([Estancias]; SAMEPERIODLASTYEAR('Date'[Date]))

Measure Estancias LY revenue

estancias LY revenue = CALCULATE([Estancias];
    FILTER(ALL(f_valoracion);f_valoracion[fecha_reserva]< [fecha ant]);
    SAMEPERIODLASTYEAR('Date'[Date]))

This last measure is that it gives me problems, as you can only see the total and I do not have the detail by type of room.

I wish someone could help me.

Thank you very much

Antoni

[v-shex-msft · Accepted solution]

HI @arossello,

Nope, power bi not support to create dynamic column/table based on slicer vs filter. I'd like to suggest you to create a dynamic measure to instead.

Calculated Column/Table Change Dynamically According to Slicer Selection in the Report.

Regards,

Xiaoxin Sheng