Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!To celebrate FabCon Vienna, we are offering 50% off select exams. Ends October 3rd. Request your discount now.
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.