Creating two tables from one data table which has totals

Anonymous — Thu, 16 Jan 2025 22:57:26 GMT

Looking for help creating a display using DAX. I have a semantic model which pushes data (totals and components in one table) to Power BI (can't create relationships in Power BI). What I would like to do is to create two tables based on the data: One table will show totals, the other table will display nothing until an item is clicked in the first table, and then shows the components. Here's an example:

Original Data:

Grouping	Item	Owner	Count
Hardware	Mouse		9
Hardware	Mouse	A	2
Hardware	Mouse	B	3
Hardware	Mouse	C	4
Hardware	Keyboard		8
Hardware	Keyboard	A	1
Hardware	Keyboard	C	2
Hardware	Keyboard	E	5
Software	Windows		2
Software	Windows	B	1
Software	Windows	D	1
Software	Power BI		2
Software	Power BI	A	1
Software	Power BI	B	1

Table of totals:

Grouping	Item	Count
Hardware	Mouse	9
Hardware	Keyboard	8
Software	Windows	2
Software	Power BI	2

When for example the first row is clicked in the table, the second table displays:

Owner	Count
A	2
B	3
C	4

Re: Creating two tables from one data table which has totals

Irwan — Fri, 17 Jan 2025 01:21:44 GMT

hello Anonymous

please check if this accomodate your need.

1. create a new measure for calculating 'Counting' value

CountValue = CALCULATE(SUM('Table'[Count]),'Table'[Owner]<>BLANK())

2. plot the measure and column in table visual for first table

3. create another table visual for second table. use visual filter to remove empty value in 'Owner' column.

Hope this will help.

Thank you.

topic Re: Creating two tables from one data table which has totals in DAX Commands and Tips

Creating two tables from one data table which has totals

Re: Creating two tables from one data table which has totals