Forum Discussion
DAX query
Hi, I have my report visualization as below. The Instance column has various sources in my data. So, for each instance, the table visual show should only 1 row per Instance i.e., if the Instance is ...
Try the following DAX measures:
Latest successful runs = MAX('Table'[Latest successful runs])
Totals = SUM('Table'[Runs])
'Table' refers to the table where you have the data.