Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
Hi Guys!
I am trying to create an overall measure which looks at the data which we are currently looking at on the dashboard vs. the entire set of data that we have.
It will be used to extrapolate the accuracy which we show on the dashboard, to the entire set.
The only filter which it should include is the datefilter as I would like to see what are the total rows within this time period vs. what aree the rows we are looking at on the dashboard currently.
My formula looks something like this:
Solved! Go to Solution.
@ryan_ward
We can use Allexcept in calcuate columns, but to create a measure try use the following filter.
@ryan_ward
We can use Allexcept in calcuate columns, but to create a measure try use the following filter.
Amazing! Thank you so much to everyonewho has assisted with this! 🙂
@ryan_ward , here ccd_count should only consider filter and context of Customs Clearance Document'[Date Filter]
if you do not want any filter then use all
Hi @amitchandak Thank you! The only filter that the ccd_count should consider is the date filter, all other filters should not affect the denominator value at all. In this way we can filter the denominator value by the date, while the numerator value will be affected by all filters on the dashboard. Sorry if I did not understand your response.
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
Check out the June 2024 Power BI update to learn about new features.
User | Count |
---|---|
91 | |
87 | |
80 | |
69 | |
69 |
User | Count |
---|---|
226 | |
129 | |
119 | |
83 | |
77 |