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
Anonymous's avatar
Anonymous
Not applicable
2 years ago

Hi nit101 ,

Please try this DAX:

TotalProgramDays = CALCULATE(
    COUNTROWS(VALUES(vProgrammeDeliveryDates[StartDate])),
    FILTER(
        ALL(vProgrammeDeliveryDates),
        vProgrammeDeliveryDates[ProgrammeName] IN VALUES(vPivotAttendance-Participant[ProgrammeName])
    )
)

But as lbendlin  says, please provide sample data, which will be helpful!

Best Regards,
Dino Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.