Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hello, I am working with data visualization and trying not to count duplicates and not seeing how to accomplish, the objective is to count only the first ocurrence, using as a filter periods of dates, years, months etc and/or filtering the other related tables.
The objective is to work only with data that is displayed dynamically according to the selected filters.
Below is some made up data that should help explain issue:
Another user from the community helped me with the issue of duplicity (v-lili6-msft ), but not work if I apply a filter to Date column or other filter of the related tables.
Measure used to count the first occurrence.
result = CALCULATE(COUNTROWS(Query),FILTER(Query,Query[DATE]=CALCULATE(MIN(Query[DATE]),ALLEXCEPT(Query,Query[ID]))))+0
In this measure, I would like to include the respective filters mentioned above. I have used the allselected function but it does not work.
Actually:
Issue when using the date filter:
Expected result using filters:
I emphasize that I can not occupy calculated columns is too much information and applying only the filters could reduce the processing times in Analysis Services 2014.
Thank You.
Hi @jarenasv
Could you paste some data or upload the file here? You can upload the .pbix file to OneDrive and post the link here. Do mask sensitive data before uploading.
Regards,
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
97 | |
96 | |
81 | |
74 | |
66 |
User | Count |
---|---|
126 | |
106 | |
105 | |
86 | |
72 |