How to show total rows based on filter irrespective of column values

iamcrj — Tue, 13 Jun 2023 18:38:15 GMT

Hello All,

I have 2 tables in my dataset as presented below -

Table 1 -

ID	Field	Detail
123	ABC	Primary
456	ABC	Primary
123	ABC	Primary
123	ABC	Secondary

Table 2

ID	Name
123	ABC
345	DEF
456	EFG

I have a filter of "Name" column in my report. Now based on the value selected in Name filter, i want to show count of values in Detail Column vs total count of rows for filter selected.

Ex. If ABC is selected in name filter,

i want to get below data

Primary=2
Secondary=1
Total Rows for ABC=3
Total Rows in Table =4

Please suggest how this can be achieved via DAX.

Re: How to show total rows based on filter irrespective of column values

lbendlin — Thu, 15 Jun 2023 01:23:10 GMT

Why not

Primary = 3

Total Rows for ABC=4

topic Re: How to show total rows based on filter irrespective of column values in DAX Commands and Tips

How to show total rows based on filter irrespective of column values

Re: How to show total rows based on filter irrespective of column values