Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago

Target Value for Gauge Metric When Filtering

Hr/Lin KM = var t= SUMMARIZE('Table1','Table1'[Pass], "Sum KM",SUM('Table1'[Linear KM]), "Sum Time",SUM('Table1'[Hours])) return SUMX(t,[Sum Time]/[Sum KM]) I currently have the above formula in r...
Need Help
richbenmintz's avatar
richbenmintz
Icon for Resident Rockstar rankResident Rockstar
7 years ago

Hi Anonymous,

 

Can you provide a pbix file with both the actual and target measures defined.

 

Thanks,

  • Anonymous's avatar
    Anonymous
    Not applicable
    7 years ago

    richbenmintzIt is company info and I don't think I can share the file. I have attached images of the behavior that I am looking for.All TestsFilter 1 Test