Forum Discussion
Table visual total
i have data like below when use max in the column and also in measure the total in the table visual showing max value instead of total. please help iam new to dax
Hi, Anonymous
You can try the following Measure.
max_original_data =
IF (
HASONEFILTER ( 'Table'[amount] ),
MAXA ( 'Table'[amount] ),
SUMX ( 'Table', 'Table'[amount] )
)
The Table visual will looks like this:
Best Regards,
Caiyun Zheng
If this post helps, then please consider Accept it as the solutions to help the other members find it more quickly.
v-cazheng-msft
Community Support
Community SupportHi, Anonymous
You can try the following Measure.
max_original_data =
IF (
HASONEFILTER ( 'Table'[amount] ),
MAXA ( 'Table'[amount] ),
SUMX ( 'Table', 'Table'[amount] )
)
The Table visual will looks like this:
Best Regards,
Caiyun Zheng
If this post helps, then please consider Accept it as the solutions to help the other members find it more quickly.