Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi! I have this measure:
Measure =
VAR FECHA = CALCULATE(MIN('DATA BASE'[DATE]),ALLSELECTED('DATA BASE'[DATE]),VALUES('DATA BASE'[resp x dep 2]))
RETURN FECHA
and in my table is returning me this:
i want to force the measure to only display the values that have information in the MIN date selected in the slicer. Similar as when I select the specific date:
I will use this variable for another measure
Thank you for the help!!
@Midguel , try like
Measure =
var _min = minx(allselected('DATA BASE'),'DATA BASE'[DATE])
RETURN
CALCULATE(MIN('DATA BASE'[DATE]),filter('DATA BASE','DATA BASE'[DATE]=_min ))
The slicer needs to be fed from an independent date table.
Create a measure that compares your fact date to the min slicer date
Show Row :=
VAR FECHA = MIN('SLICER'[DATE])
Return 'DATA BASE'[Start]=FECHA
Then filter the visual by Show Row = True
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
47 | |
26 | |
19 | |
14 | |
10 |
User | Count |
---|---|
57 | |
49 | |
44 | |
18 | |
18 |