Forum Discussion

nit101's avatar
nit101
Frequent Visitor
2 years ago

Calculating total from related dataset

Hi, I’m learning Power BI and I can’t work out how to get total from one of my datasets.  I have 2 sliders – date uses vCalendar dataset and programme names uses vProgrammes dataset.  My main repo...
Need Help
lbendlin's avatar
lbendlin
Icon for Super User rankSuper User
2 years ago

Let's do some basic data quality checks first.  Your dimension table is missing the Eastlea - BB  offering.  You also have cases where you didn't offer the programme yet still had participants.  Please clarify.

 

 

nit101's avatar
nit101
Frequent Visitor
2 years ago

I removed some data from the model for the sample, so not all the data in thedatesets will relate.  All the data in the live datasets relate. 

Yes, Eastlea - BB is missing from the dimestion table.  I kept some fact data for Eastlea - BB because when I was adding some measures to the visual, I was getting data for programmes that were not selected in the slider.