Forum Discussion
DAX Measure (Sum Similar Rows in Column A + Compare to condition + Count distinct in Column A)
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!!
don't see an error message
Sorry I meant the standard error. It no longer shows the count when I click on 2022 and 2023 individually.
please post the sample pbix.
Do not include sensitive information or anything not related to the issue or question.
If you are unsure how to upload data please refer to https://community.fabric.microsoft.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-Forum/ba-p/963216