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.