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
nit101's avatar
nit101
Frequent Visitor
2 years ago

Hi Anonymous Dino,

 

Sorry for the delay to your response. Your Dax is nearly what I what, it counts the total number of dates for a ProgrammeShortName, but I also need the date filter from the Slider.  I thought this might work but it is not filtering on date:

 

TotalProgramDays =
    CALCULATE(
        COUNTROWS(VALUES(vProgrammeDeliveryDates[StartDate])),
        FILTER(
            ALL(vProgrammeDeliveryDates),
            vProgrammeDeliveryDates[ProgrammeShortName] = ('vPivotAttendance-Participant'[PSN_ParticipantSingle])
            && vProgrammeDeliveryDates[StartDate] >= MINX( 'vCalendar', vCalendar[TheDate] )
            && vProgrammeDeliveryDates[StartDate] <= MAXX( 'vCalendar', vCalendar[TheDate] )
        )
    )
 
vCalendar is a standard date dataset that lists all dates for the slider.
 
I'm working on getting your test data - reducing the dataset size for you.
 
Thank you for your help.