Descriptive statistics table

[smann]

Would it be possible to generate something like this in Power BI? Currently, I can calculate the values individually for the variables, but I would like to have one single table if possible.

		Categorical variables	Continuous variables
	Sample Size (N)	% (n/N)	Mean	Median	SD	Range
Age	102	-	25	22	3.5	29-27
Gender:
Male	102	65.7 (67/102)	-	-	-	-
Female	102	34.3 (35/102)	-	-	-	-

[Greg_Deckler]

Maybe, would need to understand underlying source data. 

Please see this post regarding How to Get Your Question Answered Quickly: https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490

[smann]

Source data:

let
    Source = Table.FromRows(Json.Document(Binary.Decompress(Binary.FromText("i45WcszLS1XSUXJLzU3MATGMTJVidaKV3IoS84A8X6igOVjQKxFNrSFEOD8VSakxVCwDWb8JWNA7sQRVvyVY2DexKD2xKLUERcoCJlWJImwGFg7Jz0UyHOiKWAA=", BinaryEncoding.Base64), Compression.Deflate)), let _t = ((type text) meta [Serialized.Text = true]) in type table [Name = _t, Gender = _t, Age = _t]),
    #"Changed Type" = Table.TransformColumnTypes(Source,{{"Name", type text}, {"Gender", type text}, {"Age", Int64.Type}})
in
    #"Changed Type"

Expected result:

		Categorical variables	Continuous variables
	Sample Size (N)	% (n/N)	Mean	Median	SD	IQR
Age	8		25.4	25.5	2.7	3.5
Gender	7
Male		42.9% (3/7)
Female		57.1% (4/7)

[v-shex-msft]

Hi @smann,

Nope, power bi not support these analysis. Each analysis should be a measure , but current power bi not allow to use measure as axis or row label.

Regards,
Xiaoxin Sheng

[smann]

How can I dump this post?