calculate total - should be easy!

[SophRow]

Hi,

I have data from a clinical trial that looks like this:

The visualistion looks like this:

As you can see it has autocalculated the total (107 events in the first example) - how do i create a measure to show this, so i can add to another visualisation for summary purposes, and also so i can sort the x axis by totals?

Thanks so much!

Soph

[tamerj1 · Accepted solution]

Hi @SophRow 
You need to create a measure that sums the counts
COUNTA ( TableName[Column1] ) + COUNTA ( TableName[Column2] ) + COUNTA ( TableName[Column3] ) ... etc..

[Ashish_Mathur]

Hi,

Your data is not well structued.  In the Query Editor, select the first 2 columns, right click and select "Unpivot Other columns".  Now create your visual and write this measure

Participants = distinctcount(Data[Participant])

Hope this helps.

[MahyarTF · Accepted solution]

Hi,

Use below dax measure :

_CntAll = count(Sheet51[Headache])+count(Sheet51[Syncope])+count(Sheet51[Falls])+count(Sheet51[Oedema])+count(Sheet51[Kalaemia])+count(Sheet51[Hyponatraemia])

Then use it in other visuals.

For the particular Column Chart, Put the created measure(I paste it before), in Tooltips, then sort the chart based on this measure :

[tamerj1 · Accepted solution]

Hi @SophRow 
You need to create a measure that sums the counts
COUNTA ( TableName[Column1] ) + COUNTA ( TableName[Column2] ) + COUNTA ( TableName[Column3] ) ... etc..

[rodrigosan]

Hello how are you?
I didn't understand your question correctly.
Here's the example I created to see if it helps.
https://5pwtcn-my.sharepoint.com/:f:/g/personal/rodrigosan_5pwtcn_onmicrosoft_com/Ekk2Pvc89A9CoffLPi...

Did I solve your problem?
Please mark as solution so others can find this solution.
https://www.linkedin.com/in/rodrigosanpbi/