Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Good, I want to show the filters that I have selected and they work all except the date.
Since I can show the selected date, all the data is in the same table. I give you the example.
Solved! Go to Solution.
Hi @Aguirre ,
In the expression you are using the problem is that you did not close the ALLSELECTED expression try the following:
e_Fechas2 =
VAR _max =
MAXX (
ALLSELECTED ( BI_EXPEDIENTES_USUARIO ),
BI_EXPEDIENTES_USUARIO[FECHA_APERTURA]
)
VAR _mIN =
MAXX (
ALLSELECTED ( BI_EXPEDIENTES_USUARIO ),
BI_EXPEDIENTES_USUARIO[FECHA_APERTURA]
)
RETURN
_Max & _Min
Regards
Miguel Félix
Proud to be a Super User!
Check out my blog: Power BI em Português@Syndicate_Admin , Not very clear
new measure =
var _max = maxx(allselected(Date),Date[Date])
var _min = minx(allselected(Date),Date[Date])
return
"From " & _min & " to " & _max
Measure = concatenatex(allselected(Date), Date[Date], " , " )
Hello and first of all thank you.
I have achieved something, but not as you tell me, since it gives me an error, the problem I have with the allselect, I put my measurement that works, but that is not complete and I tell you, in case you can indicate the failure, as I tell you, I do not have a calendar table, but a column in the table that contains all the data.
This works but is incomplete:
Greetings
Hi @Aguirre ,
In the expression you are using the problem is that you did not close the ALLSELECTED expression try the following:
e_Fechas2 =
VAR _max =
MAXX (
ALLSELECTED ( BI_EXPEDIENTES_USUARIO ),
BI_EXPEDIENTES_USUARIO[FECHA_APERTURA]
)
VAR _mIN =
MAXX (
ALLSELECTED ( BI_EXPEDIENTES_USUARIO ),
BI_EXPEDIENTES_USUARIO[FECHA_APERTURA]
)
RETURN
_Max & _Min
Regards
Miguel Félix
Proud to be a Super User!
Check out my blog: Power BI em Portuguêsthanks to @Syndicate_Admin
It has worked for me in this way, just comment that the 2nd variable is with MINX since it appears twice MAXX.
Greetings.
Hi @Aguirre ,
Sorry for the error I just wrote the first part of the variable and paste it a second time did not change it but you are correct.
Regards
Miguel Félix
Proud to be a Super User!
Check out my blog: Power BI em PortuguêsUser | Count |
---|---|
141 | |
113 | |
104 | |
78 | |
64 |
User | Count |
---|---|
136 | |
125 | |
107 | |
70 | |
61 |