Forum Discussion

Mahadi's avatar
Mahadi
Frequent Visitor
4 years ago
Solved

Value count problem

Hello good people, I am a new Power BI learner and have encountered a problem while designing a data model. I have attached the file where I am working on ContosoDW. You can see the values are the sa...
Need Help
  • TheoC's avatar
    TheoC
    4 years ago

    @Mahadi okay, all you need to do is add a new column in the DimProduct table like below and then use the YEAR from the DimProduct table instead of the Date table.  Keep the Count of ProductName the same.

     

     

     

    Hope this helps!

     

    Theo ğŸ™‚

HotChilli's avatar
HotChilli
Community Champion
4 years ago

Hi Mahadi TheoC ,

I hope I'm not stepping on any toes but I thought I'd respond since Theo is answering from his phone.

 

The visual created has 2 fields from dimension tables (which is unusual) and if you look at the data model and  the relationship directions, they are 1:many from the dimension tables to the FactSales table.

i.e. date table ->FactSales <- product table so the date table doesn't know anything about the product table unless something from the FactSales table is involved.  A typical symptom of this sort of thing is when all the aggregation values for different dimension values are the same.

Dimension tables are used to slice and dice data from a fact table so in this instance you will need to decide what you actually want in the visual, for example, Calendar Year from the date table and count/distinct count of product ID from the FactSales table.

---

There's quite a lot to grasp here so I hope it makes sense.

Good luck in your powerbi journey.