Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
I have chart (Shown Below) in my report having multiple measures on it.These Measures are created using Calculate along with filter statment in them.
When Client drillthroughs from any measure it shows total records against Non-shipping or shipping line (Column Values) in target page.
Requirement is that if he drillthrough for any measures only those specfiic records should appear in target page.
Lets say if he drillthroughs on Positioned/qualified for Non-shipping line only 779 records should appear in detail page but right now it shows all records against Non-shipping.
I have read that drillthrough dosent pick filters applied inside a measure or which are created using "calculate".
Is there anyworkaorund for it or there is no possibility of this?
Graph:
Sample Measure:
Direct & Qualified Opportunities Count = CALCULATE(COUNT('Opportunities'[Direct & Qualified Opportunities]),FILTER(Opportunities,Opportunities[Opportunity Stage]="Positioned"),FILTER(Opportunities,Opportunities[SCO Stages]=BLANK()),FILTER(Opportunities,Opportunities[Opportunity State]="Open"))+CALCULATE(COUNT('Opportunities'[Direct & Qualified Opportunities]),FILTER(Opportunities,Opportunities[Opportunity Stage]="Positioned"),FILTER(Opportunities,Opportunities[SCO Stages]="Qualify"),FILTER(Opportunities,Opportunities[Opportunity State]="Open")).
Solved! Go to Solution.
Hi @Anonymous ,
First, your sample measure could be modified like so:
Direct & Qualified Opportunities Count =
CALCULATE (
COUNT ( 'Opportunities'[Direct & Qualified Opportunities] ),
FILTER (
Opportunities,
Opportunities[Opportunity Stage] = "Positioned"
&& (
Opportunities[SCO Stages] = BLANK ()
|| Opportunities[SCO Stages] = "Qualify"
)
&& Opportunities[Opportunity State] = "Open"
)
)
Then, maybe you could try to add your measure to "Filters on this visual" of all visuals on drillthrough page and set it as "is not blank".
BTW, .pbix file attached.
Best Regards,
Icey
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi @Anonymous ,
First, your sample measure could be modified like so:
Direct & Qualified Opportunities Count =
CALCULATE (
COUNT ( 'Opportunities'[Direct & Qualified Opportunities] ),
FILTER (
Opportunities,
Opportunities[Opportunity Stage] = "Positioned"
&& (
Opportunities[SCO Stages] = BLANK ()
|| Opportunities[SCO Stages] = "Qualify"
)
&& Opportunities[Opportunity State] = "Open"
)
)
Then, maybe you could try to add your measure to "Filters on this visual" of all visuals on drillthrough page and set it as "is not blank".
BTW, .pbix file attached.
Best Regards,
Icey
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
117 | |
104 | |
77 | |
73 | |
52 |
User | Count |
---|---|
145 | |
109 | |
109 | |
90 | |
64 |