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.
Hi Anonymous
to get the total amount use the below measure
Total Amount=
CALCULATE(sum('Order Details'[Sales])
Where Order details is your table name and Sales is the column name
Appreciate you kudos , Press the thums up button !!