topic Re: totalsum value in table visual and card in DAX Commands and Tips

totalsum value in table visual and card

reynold522 — Fri, 13 Jan 2023 10:57:46 GMT

Hi all,

I put several measure in a table visual and count of TotalSum in card visual like following graph.

table is filtered with totalSum>0 as well as date

measure TotalSum = [Charge factorN]+[Deep DischargeN]+[MinVoltageN]+[Voltage diffN]+[DischargeAhN]+[DoDoverboundaryN]

I count number of TotalSum as well and put in card visual. other filter conditiona is same with table visual. the code is as following

## of Notifications =

VAR _value =SUMX ( VALUES ( 'RUAN_GLOBALMATIX_TRACKSHEET_L_V'[XTCU_ID_NUMBER] ), IF ( [TotalSum] >0, 1,0 ) )

RETURN

IF( _Value= BLANK(), 0, _Value)

question: the number of row in visual table should be equal to number shows in card visual

what could cause the difference?

Thanks in advance

Re: totalsum value in table visual and card

amitchandak — Fri, 13 Jan 2023 13:41:09 GMT

reynold522 , Change return like

Sumx(summarize(Table, Table[XCTU_ID_NUMBER], Table[REgion], "_1", calculate(IF( _Value= BLANK(), 0, _Value))), [_1])

Re: totalsum value in table visual and card

reynold522 — Fri, 13 Jan 2023 13:56:11 GMT

this code dont work, thank you anyway

Re: totalsum value in table visual and card

Anonymous — Mon, 16 Jan 2023 08:30:53 GMT

Hi reynold522 ,

According to your case description, you first create a measure [TotalSum] to calculate as the sum of the other five measures, and then use the Sumx() function and use the Values() function inside to give your measure [TotalSum] in the context created separately for the column 'RUAN_GLOBALMATIX_TRACKSHEET_L_V' [XTCU_ID_NUMBER] Came to make an If judgment and counted.

Since the five measures you referenced in the measure [TotalSum] are not provided, my current judgment on the root cause of the problem seems to be related to the up and down questions built in your Sumx() function, because your table visual has two dimension columns. If convenient, you can try using the Summarize() function to build the context of two dimension columns, like this:

## of Notifications = VAR _value = SUMX ( SUMMARIZE ( 'RUAN_GLOBALMATIX_TRACKSHEET_L_V', [XTCU_ID_NUMBER], [REGION] ), IF ( [TotalSum] > 0, 1, 0 ) ) RETURN IF ( _Value = BLANK (), 0, _Value )

Then look at the output value, if there is still a problem, please upload your .pbix file with this problem (does not contain sensitive data).

Best Regards,

Neeko Tang

If this post  helps, then please consider Accept it as the solution  to help the other members find it more quickly.