Card Visual not totalling correctly

[GJ217]

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 they are all deselected.

The measure behined the Card is  Starters = CALCULATE(COUNT(Starters[Person Number]))  with a Relative date,  is in the last 12 calendar months Month & Year  filter 

Can anyone please tell me how to correct this?

	Headline Figures
Divison1	1326
Divison2	1266
Divison3	1072
Divison4	564
Divison5	495
Divison6	263
Divison7	133
Divison8	116
Card Total	4978

[v-rongtiep-msft]

Hi @GJ217 ,

Is the measure result incorrect?  If so, Please have a try.

Then create a measure based on the Starters.

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

You can also use other unique values instead of date columns, such as index columns.

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.

[GJ217]

Hi @v-rongtiep-msft 

I'm lost at the the "aaa" part I can't seem to find thevariable for this in the below, could you please confirm what this is?

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

[v-rongtiep-msft · Accepted solution]

Hi @GJ217 ,

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.

[GJ217]

Hi @v-rongtiep-msft 

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

[Mahesh0016]

Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.

[GJ217]

Hi  @Mahesh0016 ,

I the data set is peopla data so all of it is sensitive and it will take me some time to create a dummy copy as there are many tables.

Thanks for the offer still.