COUNTROWS Not Working After Filter Pane
Hi Guys, HOWMANYLEFT = COUNTROWS(wyscout_bio_data) I have a matrix visual in my report. When filtering is done through Slicer, the above formula tells how many rows are left in the table. However, when filtering through the filter pane, the number does not look correct. What should I do?
Seeing selected date range in a card visual
I want to show a card visual on the home page of the repport that shows the YearMonth range selected in the filter pane. I have a DimDate[MonthYear] filter on all pages and have a current selection of Jan/19 until Oct/19. This is what i want displayed in my card visual as "Jan/19 - Oct/19". Ofcourse the visual had to change depending on the filter that changes. I already have the following DAX formula but this one gives me "Oct/19 - Oct/19". I can't figure out what i have to change to get my desired outcome. Selected YearMonth = VAR MinYearMonth = CALCULATE( SELECTEDVALUE(Dim_Date[Month Year]), FILTER(Dim_Date, Dim_Date[YearMonth] = MIN(Dim_Date[YearMonth])) ) VAR MaxYearMonth = CALCULATE( SELECTEDVALUE(Dim_Date[Month Year]), FILTER(Dim_Date, Dim_Date[YearMonth] = MAX(Dim_Date[YearMonth])) ) RETURN MinYearMonth & " - " & MaxYearMonth