Forum Discussion
DAX Measure (Sum Similar Rows in Column A + Compare to condition + Count distinct in Column A)
Hello Experts, I need your help with a measure issue: Objective: My measure should count distinct number of 'products' based in each card visual for: High Users High Usage (Users >=50 && Usage...
Like this?
Thank you lbendlin . I brokedown the query to suit each one card visual - High users High Usage, High Users Low Usage, Low users High Usage, Low Users Low Usage.
The issue I have a slicer for 'Year' and it used to show individual count for a particular year.
Now when I click on individual year selection, it breaks my measure (Shows an error - See details). How can I keep the individual year count when I select year 2022 or 2023 but it should show the combined count when year is NOT selected (Default or all selected).
lbendlin Thanks so much again!!
