Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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) | - | - | - | - |
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
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) |
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
How can I dump this post?
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
110 | |
94 | |
82 | |
66 | |
58 |
User | Count |
---|---|
151 | |
121 | |
104 | |
87 | |
67 |