User Profile
Sowrabha_S
Frequent Visitor
Joined 1 year ago
User Widgets
Contributions
Help with DAX
Hello All, I need help with DAX. I have 3 columns in my data set. BU,EmailId and End Date. I also have a dropdown on End Date in the dashboard. I need to calculate the count of email ids for every business unit between Jan 1st 2025 and the selected value of end date from the dropdown. I also need to count the the number of email ids with 1 count, 2 counts and 3 counts (frm the above result set) as 3 seperate measures and display in the table as Business Unit, 1 Click count, 2 Click Count and 3 Click Count. Currently I am following this approach: First Measure: Total Count = VAR SelectedEndDate = SELECTEDVALUE(RO[END_DATE]) -- Or DateTable[Date] if slicer is from a date table VAR StartDate = DATE(2025, 1, 1) RETURN CALCULATE( COUNT(RO[EMAIL_ADDRESS]), ALL(RO[END_DATE]), RO_CLICKERS[END_DATE] >= DATE(2025,1,1) && RO_CLICKERS[END_DATE] <= SelectedEndDate) 2nd measure: Onetimeclickers = CALCULATE (COUNTROWS(FILTER(VALUES(RO_CLICKERS[EMAIL_ADDRESS]), [Total Count] = 1))) TwoTimeClickers = CALCULATE (COUNTROWS(FILTER(VALUES(RO_CLICKERS[EMAIL_ADDRESS]), [Total Count] = 2))) ThreeTimeClickers = CALCULATE (COUNTROWS(FILTER(VALUES(RO_CLICKERS[EMAIL_ADDRESS]), [Total Count] = 3))) This is giving the counts only for the selected month from the dropdown (for ex: Mar 31st 2025) not between Jan 1st and March 31st. Example screenshot for reference: Appreciate your help!Tooltip on a specific column in TABLE visual with Report Page option
Hello everyone, My requirement is to click on a specific column and a specific value (row) say column number 2 and row number 3 in a table and it should display a tooltip (created in a different page - using report page option). I cannot use matric for my requirements also not a blank text box at the column header as different values in thay column has different values in the tooltip.I know there are many other posts related to this. However I could not find any solution that suit my requirements. Appreciate any solution or workaround ! Thanks, Sowrabha
