Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Hi
i have a new problem, this is my visualization:
The three filters in the top left only affect to the table in the left, and the three filters in the top right only affect to the table in the right, i want to add another field in the leff table with this expression: % VENTAS (left table) / % VENTAS (right table)
it´s possible?
Regards
Solved! Go to Solution.
Thanks Cherie for Answer, but i found the solution to my problem based on your tip
i make the 6 filters apply to the table, and create 2 new measures:
VENTAS TOTALES1 = CALCULATE([VENTAS TOTALES];ALL('FILTRO_AÑOS2'[Año]);ALL(FILTRO_HIPODROMO2[NOMBRE_HIP]);ALL(FILTRO_REUNIONES2[RN_NUMERO_REUNION]))
and
VENTAS TOTALES2 = CALCULATE([VENTAS TOTALES];ALL('FILTRO_AÑOS1'[Año]);ALL(FILTRO_HIPODROMO1[NOMBRE_HIP]);ALL(FILTRO_REUNIONES1[RN_NUMERO_REUNION]))
Regards
Hi @andrescaso
You may try to add two slicer table first. Then create measures for your left and right table. Show a simplified sample as below:
MeasureBySlicer1 = CALCULATE(SUM(Table1[ventas]),FILTER(Table1,Table1[year]=SELECTEDVALUE(Slicer1[year])))
MeasureBySlicer2 = CALCULATE(SUM(Table1[ventas]),FILTER(Table1,Table1[year]=SELECTEDVALUE(Slicer2[year])))
Measure 2 = [MeasureBySlicer2]/[MeasureBySlicer1]
Regards,
Cherie
Thanks Cherie
I try all the week, but something it´s wrong
I created the two table slicer, for make a different filters
This are my measure 1
and this my measure 2
I experiment only with the left table and only the year filter, i put no filter affect this table, but, the measure 1 (VENTAS TOTALES1) don´t show any value
any idea?
Regards
Hi @andrescaso
It's better that if you could share some simplified data which could reproduce your scenario and your desired output. You can upload it to OneDrive or Dropbox and post the link here.
Regards,
Cherie
Thanks Cherie for Answer, but i found the solution to my problem based on your tip
i make the 6 filters apply to the table, and create 2 new measures:
VENTAS TOTALES1 = CALCULATE([VENTAS TOTALES];ALL('FILTRO_AÑOS2'[Año]);ALL(FILTRO_HIPODROMO2[NOMBRE_HIP]);ALL(FILTRO_REUNIONES2[RN_NUMERO_REUNION]))
and
VENTAS TOTALES2 = CALCULATE([VENTAS TOTALES];ALL('FILTRO_AÑOS1'[Año]);ALL(FILTRO_HIPODROMO1[NOMBRE_HIP]);ALL(FILTRO_REUNIONES1[RN_NUMERO_REUNION]))
Regards
User | Count |
---|---|
124 | |
108 | |
99 | |
62 | |
62 |
User | Count |
---|---|
137 | |
115 | |
102 | |
71 | |
61 |