Forum Discussion
How to do total power BI table value
Hi,
Kindly help me the below issue.
i am trying to set the each customer table total when i selece sum
its different values is coming this same way i am trying to give max table inside correct values appearing but i am not getting the table total also max not able get calculate value..
hi Anonymous
If you want to have Total of max value try to use this measure dax
MAX Measure = VAR _Table = ADDCOLUMNS( SUMMARIZE( Table anme, Column1, column2, Column 3 ), "@MaxSales", VAR _MAX = CALCULATE(MAX(Table[Date])) VAR _Result = CALCULATE( SUM(Sales), Table[Date] = _MAX ) RETURN _Result ) VAR _Result = SUMX(_Table, [@MaxSales]) RETURN _ResultTry to modify above dax with your column name.
this similar dax you need to create for all 4 columns
I hope I ansswered your question!
3 Replies
hi Anonymous
If you want to have Total of max value try to use this measure dax
MAX Measure = VAR _Table = ADDCOLUMNS( SUMMARIZE( Table anme, Column1, column2, Column 3 ), "@MaxSales", VAR _MAX = CALCULATE(MAX(Table[Date])) VAR _Result = CALCULATE( SUM(Sales), Table[Date] = _MAX ) RETURN _Result ) VAR _Result = SUMX(_Table, [@MaxSales]) RETURN _ResultTry to modify above dax with your column name.
this similar dax you need to create for all 4 columns
I hope I ansswered your question!
Hi Anonymous
Try this dax also
Sum of Max = SUMX(
SUMMARIZE(TableName, TableName[City], "Max Sales", MAX(TableName[Sales])),[Max Sales])
I hope this would also give you correct result