Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago

How to create average for Measures

Data Model Scenario:  - Dimension Product Table which contains Product ID, Product Name, Dept Name, and Division Name  - Fact Table which contains Transaction ID, Product ID Problem: I created th...
average
Measures
sturlaws's avatar
sturlaws
Icon for Resident Rockstar rankResident Rockstar
7 years ago

Hi Anonymous,

 

not sure if I understand what you are after, your naming conventions are a bit confusing.

 

Could you try this and see if it gives you what you need:

average pr department =
DIVIDE (
    [Dep count];
    CALCULATE (
        DISTINCTCOUNT ( 'Table'[Product name] );
        ALL ( 'Table'[Product name] )
    )
)