Forum Discussion
DAX Measure (Sum Similar Rows in Column A + Compare to condition + Count distinct in Column A)
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/963216Hello 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.