Forum Discussion
Solved
Need Help Summing a Distinct Count in a Matrix Across all Rows
Hello, I'm trying to sum a distinct count of days within a Matrix in Power BI. There are 3 distinct dates (8/1 through 8/3) with a value of 1 for 'Unique Days' across all rows - see image below. ...
Okay I was making this way more complicated than needed.
The following measure solved my issue:
Unique Days = CALCULATE(DISTINCTCOUNT(DS_main_for_usa[CALENDAR_DATE]),DS_main_for_usa[UNIQUEDAYS]<>BLANK())
Mahesh0016 - thank you so much for answering my question. Unfortunately, that meaure still returns a value of 4 instead of 3. Any ideas?
Okay I was making this way more complicated than needed.
The following measure solved my issue:
Unique Days = CALCULATE(DISTINCTCOUNT(DS_main_for_usa[CALENDAR_DATE]),DS_main_for_usa[UNIQUEDAYS]<>BLANK())