March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early bird discount ends December 31.
Register NowBe one of the first to start using Fabric Databases. View on-demand sessions with database experts and the Microsoft product team to learn just how easy it is to get started. Watch now
Table | NP ID | Provider Full Name | Drug | Market Share Numerator | Market Share Denominator | Expected Output |
PROD | 130928288 | Pentakota Jagadeesh | Xamorin | 51392 | 0 | 0.570819266 |
PROD | 130928288 | Pentakota Jagadeesh | Xamorin | 0 | 0 | 0.570819266 |
PROD | 130928288 | Pentakota Jagadeesh | Xamorin | 0 | 90032 | 0.570819266 |
PROD | 130928288 | Pentakota Jagadeesh | Xamorin | 0 | 0 | 0.570819266 |
PROD | 130928288 | Pentakota Jagadeesh | Xamorin | 0 | 0 | 0.570819266 |
PROD | 130928288 | Pentakota Jagadeesh | Remora | 0 | 0 | 1 |
PROD | 130928288 | Pentakota Jagadeesh | Remora | 0 | 35061 | 1 |
PROD | 130928288 | Pentakota Jagadeesh | Remora | 35061 | 0 | 1 |
PROD | 130928288 | Pentakota Jagadeesh | Remora | 0 | 0 | 1 |
PROD | 130928288 | Pentakota Jagadeesh | Remora | 0 | 0 | 1 |
PROD | 123456788 | Vinay kumar | Aftarimin | 0 | 0 | 1 |
PROD | 123456788 | Vinay kumar | Aftarimin | 0 | 69330 | 1 |
PROD | 123456788 | Vinay kumar | Aftarimin | 69330 | 0 | 1 |
PROD | 123456788 | Vinay kumar | Aftarimin | 0 | 0 | 1 |
PROD | 123456788 | Vinay kumar | Aftarimin | 0 | 0 | 1 |
PROD | 123456788 | Vinay kumar | Aftarimin | 0 | 0 | 1 |
Channel | 190308883 | Santosh babu | Dolo65 | 0 | 0 | 4 |
Channel | 190308883 | Santosh babu | Dolo65 | 100 | 0 | 4 |
Channel | 190308883 | Santosh babu | Dolo65 | 0 | 25 | 4 |
Above is my Data Model and i was looking for the Dax Query to get my output as Column called "Expected Output" in the Above Table.
The output should be Max of (Market Share Numerator)/ Max(Market Share Denominator) wrt Drug for PROD Table
NPI ID is Unique for every provider
=CALCULATE(
DIVIDE(MAX(Table1[Market Share Numerator]),MAX(Table1[Market Share Denominator])),
ALLEXCEPT(Table1,Table1[NP ID],Table1[Drug]))
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!
User | Count |
---|---|
27 | |
17 | |
16 | |
12 | |
11 |
User | Count |
---|---|
35 | |
26 | |
26 | |
20 | |
15 |