Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

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  
Data Protection
General Comment
Interesting Links
Need Help
Show and Tell
Tips and Tricks
Tutorial Requests
  • v-cazheng-msft's avatar
    v-cazheng-msft
    5 years ago

    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.

BA_Pete's avatar
BA_Pete
Super User
5 years ago

Hi Anonymous ,

 

Could you take a look through this thread and mark any answers that have solved your issue as the solution(s) please? This will help others with the same issue to find the answer quicker.

 

If none of these solve the issue for you, can you provide some more details about where they fall down so we can work to get this resolved for you?

 

Thanks,

 

Pete