Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
Let's say I have a 450,000 x 70 table.
One of the 70 table columns is "Date", which contains dates for each row entry.
I have a report page in PBI that contains about 8 slicers.
Each slicer provides selection over the values of one column out of the 70 columns of this table. So there's a total of 8 different columns throughout the 8 different slicers.
I want to calculate a date measure, such that it returns the maximum date available after applying all 8 slicer selections. Could anyone help with this?
Really? Perhaps I am missing something?
A simple MAX('Table'[Date]') is not returning the MAX date out of all available dates.
maxx(allselected(table),table[date])
@jcc3508
Ok, now it is clear that you have a visual filter context that needs to be removed. The following formula should provide the result regardles of the filter context of the visual.
=
CALCULATE (
MAX ( 'Table'[Date] ),
ALLEXCEPT (
'Table',
'Table'[Column1],
'Table'[Column2],
'Table'[Column3],
'Table'[Column4],
'Table'[Column5],
'Table'[Column6],
'Table'[Column7]
)
)
User | Count |
---|---|
25 | |
11 | |
8 | |
6 | |
6 |
User | Count |
---|---|
30 | |
13 | |
11 | |
9 | |
6 |