Forum Discussion

roopa_123's avatar
roopa_123
Helper I
4 years ago

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 ...
Need Help
Show and Tell
webportal's avatar
webportal
Impactful Individual
4 years ago

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.

 

  • roopa_123's avatar
    roopa_123
    Helper I
    4 years ago

    Hi webportal ,

    Thanks for your quick reply.

    I have actually used Latest(startdate) and Count(startdate) for LatestSuccessfulRuns and TotalSuccessfulRuns columns respectively (here startdate is one of the columns of my table). But how do I get the values for failed runs and failed count?
    Is there any other way to get my requirement to be implemented? something like creating a dynamic tables using DAX?

    Help is appreciated! Thanks in advance!