Need help with measures combining two tables

[malguera]

Hello Team,

Need some help, I've been trying to sort this out using different combinations of DAX Formulas and I'm still missing a couple of what should be simple measures but for some reason it has been a nightmare on the way is interacting with the rest of the things.

Long story short (trying to simplify the Business Case)

1. Have 2 Tables (Table 1 with Sales Details and Table 2 with Hierarchy Account List)
    1.1. We may have Accounts from Table 2 (universe of accounts) that have no Sales in Table 1

2. You can have in the raw data (Table 1) something like this (obviously with a ton of more details):

3. There is a second table with Account "Universe"

4. We should be able to get the following measures (some examples):

Need your help to try to get the last 2 measures:

A. Accounts with Product A ONLY and

B. % Accounts with Product A Only vs Table 2 (Account Universe)

Note: Measures should interact based on selected filtered criteria and be able to visualize in Matrix or Charts

I know is very simple, but there is something that I'm missing reason why I would like to start from scratch with your inputs. Any help is more than welcome!

Thanks,

Mario

[Zubair_Muhammad · Accepted solution]

@malguera

May be you can add another FILTER expression inside CALCULATE

Accounts with Product A only =
CALCULATE (
    DISTINCTCOUNT ( Table1[Account] ),
    FILTER (
        ALLSELECTED ( Table1[Account] ),
        CALCULATE ( DISTINCTCOUNT ( Table1[Product] ) = 1 )
    ),
    Table1[Product] = "A"
)

[malguera]

Thanks Zubair! Seems is working fine, I'll finalize the Dashboard to see how the measure interacts with the rest of calculations.
Very much appreciated!