Join us for an expert-led overview of the tools and concepts you'll need to pass exam PL-300. The first session starts on June 11th. See you there!
Get registeredPower BI is turning 10! Let’s celebrate together with dataviz contests, interactive sessions, and giveaways. Register now.
Hi Hope all is well
I'm kind stuck on something that is really confusing me any help will be appreciated. Is there anyway to create a measure that uses a page filter ?
@Anonymous , Not very clear.
The measure should filter of page filter.
The information you have provided is not making the problem clear to me. Can you please explain with an example.
Appreciate your Kudos.
Thanks for the reply @amitchandak , sorry for the informative example . So currently I have created this measure
(Zero Measure = Sum('Query1'[count(transaction_id)]) + 0) to calcuate when a company has made zero updates on the application. I also have a filter for company_name column which only selects the companies I want. However it seem when I add this measure with the company_name column to a visual it shows even the companies I have filtered out . My question is what would be causing this issue ? and how can it be fixed . Hopefully you made sense from that
Hi @Anonymous
You might consider providing your dummy pbix that would be helpful for us to investigate it further.
You can upload it to the onedrive for business and share the link here. please don't forget to disclose the expected results and remove the confidential info.
User | Count |
---|---|
84 | |
76 | |
74 | |
48 | |
39 |
User | Count |
---|---|
114 | |
56 | |
51 | |
42 | |
42 |