Forum Discussion
Measure to countrows based on filtered results
If you want to filter them out of the data, then do this in Power Query before it loads the SharePoint list into the model. You'd need to post some sample data (mock itup in Excel for example) and show us what you are doing, but don't make your DAX overly complex because there is data there you don't want. Get rid of the data. That is Power Query's job.
A little bit of Power Query makes your DAX life a whole lot easier. 😁
How to get good help fast. Help us help you.
How To Ask A Technical Question If you Really Want An Answer
How to Get Your Question Answered Quickly - Give us a good and concise explanation
How to provide sample data in the Power BI Forum - Provide data in a table format per the link, or share an Excel/CSV file via OneDrive, Dropbox, etc.. Provide expected output using a screenshot of Excel or other image. Do not provide a screenshot of the source data. I cannot paste an image into Power BI tables.
Community ChampionIf you want to filter them out of the data, then do this in Power Query before it loads the SharePoint list into the model. You'd need to post some sample data (mock itup in Excel for example) and show us what you are doing, but don't make your DAX overly complex because there is data there you don't want. Get rid of the data. That is Power Query's job.
A little bit of Power Query makes your DAX life a whole lot easier. 😁
How to get good help fast. Help us help you.
How To Ask A Technical Question If you Really Want An Answer
How to Get Your Question Answered Quickly - Give us a good and concise explanation
How to provide sample data in the Power BI Forum - Provide data in a table format per the link, or share an Excel/CSV file via OneDrive, Dropbox, etc.. Provide expected output using a screenshot of Excel or other image. Do not provide a screenshot of the source data. I cannot paste an image into Power BI tables.
Thank you!! Much appreciated.
Yes, that is what I'm going to do and that makes the most sense. I'd much rather straighten things out there and should have thought about that.
Okay, so I had a chance to try it out this week and it didn't get the results I was looking for. So, I'm guessing a little more explanation of the requirements on my end would be helpful.
I have a sharepoint list with the list of people, positions, and their start/end dates which I tie into the positions table for the amount of monthly visit required by that person bases on their position.
The way I have it currently, if I have a new person starting/or leaving, their required visits are displayed in my display table from the start of the year whether they started in May or whenever. I would like the slicer selection reflect on the amount of visits required based on who was in the position for that particular month.
name
position
start
end
bob
manager
2021-01-01
2100-01-02
pete
manager
2021-05-16
2100-01-02
sue
supervisor
2021-01-01
2100-01-02
frank
supervisor
2021-01-01
2100-01-02
position
visits required
table containing list of visits
jeff
president
2021-04-16
2100-01-02
president
1
paul
manager
2021-01-01
2100-01-02
manager
2
tim
manager
2021-01-01
2100-01-02
supervisor
4
steve
supervisor
2021-03-16
2100-01-02
sam
supervisor
2021-01-01
2100-01-02
stu
supervisor
2021-01-01
2100-01-02
Display table
beth
supervisor
2021-01-16
2100-01-02
month slicer
name
required visits
visits completed
jim
supervisor
2021-01-01
2100-01-02
jan
james
supervisor
2021-01-01
2100-01-02
feb
gord
supervisor
2021-01-16
2100-01-02
mar
may
supervisor
2021-01-01
2100-01-02
etc.
mary
supervisor
2021-01-01
2100-01-02
