Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Hi! i'm trying to replicate the file i'm uploading here https://we.tl/t-3aY9nitu88 in PBI
U can see in the file:
1. Raw Data
2. The table i would like to see in PBI
The mandatory thing is that i need to use subtotal formula and not just count() or sum().
Thanks!!!
Solved! Go to Solution.
Hey @Migsmix ,
let's say your table with the RAW DATA is called myTable. Then create 3 measures:
Subtotal (Count) = COUNTROWS(myTable)
Then for the SUM:
Subtotal (SUM) = SUM(myTable[Purchases])
And the frequency:
Frequency = [Subtotal (SUM)] / [Subtotal (Count)]
Create a matrix in Power BI, put the color to the columns all the 3 measures to the values:
Afterwards go to the format tab and under the "Values" section set the check box to "Show on rows":
This should give you the result you want:
Hey @Migsmix ,
let's say your table with the RAW DATA is called myTable. Then create 3 measures:
Subtotal (Count) = COUNTROWS(myTable)
Then for the SUM:
Subtotal (SUM) = SUM(myTable[Purchases])
And the frequency:
Frequency = [Subtotal (SUM)] / [Subtotal (Count)]
Create a matrix in Power BI, put the color to the columns all the 3 measures to the values:
Afterwards go to the format tab and under the "Values" section set the check box to "Show on rows":
This should give you the result you want:
User | Count |
---|---|
139 | |
113 | |
103 | |
73 | |
63 |
User | Count |
---|---|
136 | |
125 | |
107 | |
70 | |
61 |