Forum Discussion
Card Visual not totalling correctly
- Anonymous3 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.
Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.
- Anonymous3 years agoNot applicable
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.