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...
Hello lbendlin ,
As mentioned in my initial post, it is a sample mocked up data to make sure my measures were working correctly. What happened after the update I made based on your response, it wiped out my calculations that were correctly working individually for each year. Also, as mentioned I have a 'Year' Slicer. To clarify, when I click on 2022, it should show me 2022 counts, similarly for 2023. When I unselect both years (default selection), it should show me combined count.
Thanks,
Ash
I cannot assist you if you are unable to provide sample data. I hope someone else can help you further.