Forum Discussion
Helper IHow to Allow a User to easily Filter for Any Project between two dates
Hi, DataUser
Please check the below picture and the sample pbix file's link down below, whether it is what you are looking for.
the measure is in the sample pbix file.
At this moment, I did not create any relationship between two tables, but if you need it later, you can create an inactive relationship and use USERELATIONSHIP DAX function in a measure.
https://www.dropbox.com/s/wmhkjkfuhs5n79e/datauser.pbix?dl=0
Hi, My name is Jihwan Kim.
If this post helps, then please consider accept it as the solution to help other members find it faster, and give a big thumbs up.
Super UserHi, DataUser
Please check the below picture and the sample pbix file's link down below, whether it is what you are looking for.
the measure is in the sample pbix file.
At this moment, I did not create any relationship between two tables, but if you need it later, you can create an inactive relationship and use USERELATIONSHIP DAX function in a measure.
https://www.dropbox.com/s/wmhkjkfuhs5n79e/datauser.pbix?dl=0
Hi, My name is Jihwan Kim.
If this post helps, then please consider accept it as the solution to help other members find it faster, and give a big thumbs up.
DataUserLastly - Is there anyway to count the number of times this measure is true? For example, in your example , it would show up as 4? I was trying to use a datacard to do this, but I can't figure out how to count what the measure has returned and I don't want to create another table.
- Jihwan_Kim
Hi, DataUser
Pleaes check the below picture and the sample pbix file's link down below.
The measure for counting active project is like below.
Project Active Count =CALCULATE (COUNTROWS(Projects),FILTER (Projects,Projects[Project Start] <= MAX ( dates[Date] )&& Projects[Project End] >= MIN ( dates[Date] )))