Forum Discussion

Reigning_data's avatar
Reigning_data
Frequent Visitor
7 years ago
Solved

Displaying ISINSCOPE

Hi all,   I have an issue which I will try to explain as best I can.   Companies A, B and C all sell various types of computers and desks. However, Comapny A does NOT sell standing desks, while B...
Need Help
  • AkhilAshok's avatar
    AkhilAshok
    7 years ago

    You can easily solve the issue by converting you model to a Star Schema. 

     

    1. Create 2 new tables as below:

    Company = DISTINCT('Table'[Company])

Product = DISTINCT('Table'[Product Type])

    2. Create 2 new relationships:

    Table[Company] <- Company[Company]

    Table[Product Type] <- Product[Product Type]

     

    3. Now replace the dimensions in your existing visuals & slicers with the columns from the new Lookup tables.

     

    4. Just use the same old measure for Market Share:

    Market Share =
DIVIDE ( [Total Value], CALCULATE ( [Total Value], ALL ( 'Table'[Company] ) ) )

    The issue you faced is happening because of the Auto Exists feature in DAX.

     

     

AkhilAshok's avatar
AkhilAshok
Solution Sage
7 years ago

You can easily solve the issue by converting you model to a Star Schema. 

 

1. Create 2 new tables as below:

Company = DISTINCT('Table'[Company])

Product = DISTINCT('Table'[Product Type])

2. Create 2 new relationships:

Table[Company] <- Company[Company]

Table[Product Type] <- Product[Product Type]

 

3. Now replace the dimensions in your existing visuals & slicers with the columns from the new Lookup tables.

 

4. Just use the same old measure for Market Share:

Market Share =
DIVIDE ( [Total Value], CALCULATE ( [Total Value], ALL ( 'Table'[Company] ) ) )

The issue you faced is happening because of the Auto Exists feature in DAX.

 

 

Reigning_data's avatar
Reigning_data
Frequent Visitor
7 years ago

You, Sir

 

are magnificent!