Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago
Solved

Card Visual not totalling correctly

Hi All, I a Card Visiual that showing a total of 4978 instead of 5235. When you click on the Divisions individually the correct values come back but do not sum correclty as a total in the card when ...
Need Help
Show and Tell
Tips and Tricks
  • Anonymous's avatar
    Anonymous
    3 years ago

    Hi Anonymous ,

    I have created a simple sample, please refer to it to see if it helps you.

    starters_ = MAX('Table'[value])
    measure = var _a = 'table'[starters_]
var _b = SUMMARIZE('table','table'[date],"aaa", 'table'[starters_])
return
IF(HASONEVALUE('table'[date]),_a,SUMX(_b,[aaa]))

     

     "aaa" is a new column in the table _b. It is 'table'[starters_] in the table _b.

     

    You can understand it in conjunction with my simple example.

     

    How to Get Your Question Answered Quickly 

     

    If it does not help, please provide more details with your desired output and pbix file without privacy information (or some sample data) .

     

    Best Regards
    Community Support Team _ Polly

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Anonymous's avatar
Anonymous
Not applicable
3 years ago

Hi Anonymous ,

I have created a simple sample, please refer to it to see if it helps you.

starters_ = MAX('Table'[value])
measure = var _a = 'table'[starters_]
var _b = SUMMARIZE('table','table'[date],"aaa", 'table'[starters_])
return
IF(HASONEVALUE('table'[date]),_a,SUMX(_b,[aaa]))

 

 "aaa" is a new column in the table _b. It is 'table'[starters_] in the table _b.

 

You can understand it in conjunction with my simple example.

 

How to Get Your Question Answered Quickly 

 

If it does not help, please provide more details with your desired output and pbix file without privacy information (or some sample data) .

 

Best Regards
Community Support Team _ Polly

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Anonymous's avatar
Anonymous
Not applicable
3 years ago

Hi Anonymous 

Thank you.

Your example makes sense  and when you add the measure to a card it shows the correct Total of 46. However my model is complicated in that the Starters table lists each person with their start date by row.

 

I have the following measures for Starters to get the Value column you have in your example:

Starters Count = COUNT(Starters[Person Number])
Starters = CALCULATE([Starters Count],USERELATIONSHIP(Dates[Date],Starters[Work Relationship Start Date]))+0