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 ğŸ™‚

TheoC's avatar
TheoC
Community Champion
4 years ago

Hi Mahadi 

 

Can you use this measure and let me know if it works:

 

Measure = COUNTROWS ( Table )

 

Then drag it to the table visual? Apologies, on phone so can't download file.

 

hope this helps.

Theo

TheoC's avatar
TheoC
Community Champion
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 🙂