The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredCompete to become Power BI Data Viz World Champion! First round ends August 18th. Get started.
Hi all, this is the relationship that I just drag to a workpage. Is there any way that I can get the number of ocurrence of each category (i.e. column 3) to get some thing like:
column1 column 2 column 3
20/04/2016 12:00:00 AM Residence: (count)
Business affairs: (count)
Anyone can provide some hint? Thanks
# Residence =
calculate
countrows(table),
table[category] = "Residence"
)
idem Business affairs.
Select the matrix chart, date, time and the measures to the matrix.
User | Count |
---|---|
16 | |
8 | |
7 | |
6 | |
6 |
User | Count |
---|---|
25 | |
13 | |
12 | |
8 | |
8 |