Forum Discussion
Post Patronactivity present in more days
Hi, Giada_Togliatti
Please check the below picture and the sample pbix file's link down below.
I tried to create a sample pbix file based on the explanation.
I suggest not having an active relationship like the below picture.
If you need to create a measure based on the active relationship, you can always activate it inside the measure by using USERELATIONSHIP function.
All measures are in the sample pbix file.
Activity Count =CALCULATE (COUNTROWS ( Activities ),FILTER (Activities,Activities[Start] <= MAX ( 'Calendar'[Date] )&& Activities[End] >= MIN ( 'Calendar'[Date] )))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.
Linkedin: linkedin.com/in/jihwankim1975/
Twitter: twitter.com/Jihwan_JHKIM
Hi, Giada_Togliatti
Thank you for your feedback.
If you have one active relationship, please try to write something like below.
You can put ALL function inside the measures, to remove filters.
I have created one active relationship in my sample, and please have a look.
https://www.dropbox.com/s/dgiy8822ljhqgqr/giada.pbix?dl=0
Activity Count =CALCULATE (COUNTROWS ( Activities ),FILTER (ALL(Activities),Activities[Start] <= MAX ( 'Calendar'[Date] )&& Activities[End] >= MIN ( 'Calendar'[Date] )))
Post PatronJihwan_Kim , the solution works, but for other visualization I should have that relationship active, do you know how to modify the formula that ignores the relationship for only this measure?
Thank you
Super UserHi, Giada_Togliatti
Thank you for your feedback.
If you have one active relationship, please try to write something like below.
You can put ALL function inside the measures, to remove filters.
I have created one active relationship in my sample, and please have a look.
https://www.dropbox.com/s/dgiy8822ljhqgqr/giada.pbix?dl=0
- Giada_Togliatti
thank you, it works!