Forum Discussion

Neal1988's avatar
Neal1988
Regular Visitor
5 years ago
Solved

Measure total in a Card Visual

i have the following measure that calulates the value for each row in a table visual.   RunRate = VAR DayNoOfYear = DATEDIFF(DATE(maxx(Points,Points[SurveyDateYear]),1,1), maxx(points,[StartDa...
  • Neal1988's avatar
    Neal1988
    5 years ago

    I found the solution and it was to wrap a new measure in a Sumx(Summarize( which then gave the correct figures in a card.

Dhrubojit's avatar
Dhrubojit
Frequent Visitor
5 years ago

Hi Neal  Please attach the sample data and PBIX , you can remove your confidential data and just give part of it . .so that we can analyze better . . because it depends on what your data is

  • Neal1988's avatar
    Neal1988
    Regular Visitor
    5 years ago

    Hi, unfortunately all of it is confidential as we have a very strict privacy policy. 
    if you have any ideas that i could try, that would be appreciated.

     

    For a bit of context, i have a table visual and one column is a staff members start date and the messure above calculates whats their score would of been if they where employeed at the start of the year. and it's this column that i need totalled, and put into a card.