VikramAdiHelper II2 years agoSolvedHow to get counts based on selected max date with created date and validated date Attched screen shot example need to convert in DAX. Please help me here.dax ryan_mayu2 years agoVikramAdi you can try this Measure = CALCULATE(count('Table'[Username]),FILTER('Table','Table'[Created date]<=max('date'[Column])&&'Table'[Valid to Date]>=max('date'[Column]))) pls see the attachment belowget counts.pbix22 KB
ryan_mayu2 years agoVikramAdi you can try this Measure = CALCULATE(count('Table'[Username]),FILTER('Table','Table'[Created date]<=max('date'[Column])&&'Table'[Valid to Date]>=max('date'[Column]))) pls see the attachment belowget counts.pbix22 KB
ryan_mayu2 years agoVikramAdi you can try this Measure = CALCULATE(count('Table'[Username]),FILTER('Table','Table'[Created date]<=max('date'[Column])&&'Table'[Valid to Date]>=max('date'[Column]))) pls see the attachment belowget counts.pbix22 KB
1 ReplyReplies sorted by Most Likedryan_mayuSuper User2 years agoVikramAdi you can try this Measure = CALCULATE(count('Table'[Username]),FILTER('Table','Table'[Created date]<=max('date'[Column])&&'Table'[Valid to Date]>=max('date'[Column]))) pls see the attachment belowget counts.pbix22 KB
ryan_mayuSuper User2 years agoVikramAdi you can try this Measure = CALCULATE(count('Table'[Username]),FILTER('Table','Table'[Created date]<=max('date'[Column])&&'Table'[Valid to Date]>=max('date'[Column]))) pls see the attachment belowget counts.pbix22 KB
Related contentTheme Validation ErrorValidation/optimisation options for AI featuresValidate Slicer SelectionDAX Measure for Ranking the valid rows and calculating the average ratingCan i use a measure selected in a slicer (created with field parameters) to create a rank?
Helper II
