Forum Discussion
shippen70
Helper I
Helper ISummarize Table and Remove Duplicates
I am working with a table of data that I am trying to summarize. For development I am using New Table and Summarizing. I get the first level of summary to work but my table ends up with some duplic...
Try distinct(Table)
or in case summarize group by what you distinct first and take measure with rename post that.
You can use table inplace of summarize
countrows(
SUMMARIZE('_AELaborEdit - Clock In Date',
'_AELaborEdit - Clock In Date'[ClockInDate],
'_AELaborEdit - Clock In Date'[Job],
'_AELaborEdit - Clock In Date'[Operation],
"Operations Count",
COUNTROWS('_AELaborEdit - Clock In Date'))or
countx(
SUMMARIZE('_AELaborEdit - Clock In Date',
'_AELaborEdit - Clock In Date'[ClockInDate],
'_AELaborEdit - Clock In Date'[Job],
'_AELaborEdit - Clock In Date'[Operation],
"Operations Count",
COUNTROWS('_AELaborEdit - Clock In Date')
)
), [Operations Count])https://www.sqlbi.com/articles/from-sql-to-dax-joining-tables/
