Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now! Learn more
Hi Experts
How would i apply an addtional filter to the following DAX
Measure =
VAR __Table = FILTER('eda_edetailing_slides_used', [drmf_clm_presentation_slide_id] <> BLANK())
VAR __Column1 = SELECTCOLUMNS(__Table,"__Column",[crm_call_name])
VAR __Column2 = SELECTCOLUMNS(__Table,"__Column",[crmf_hcp_id])
RETURN
COUNTROWS(DISTINCT(UNION(__Column1, __Column2)))Filter
eda_edetailing_slides_used[activity_type_1] IN {"f2f", "Virtual"}))
Solved! Go to Solution.
MyMeasure =
VAR __Table =
FILTER (
'eda_edetailing_slides_used',
NOT ( ISBLANK ( [drmf_clm_presentation_slide_id] ) )
&& eda_edetailing_slides_used[activity_type_1] IN { "f2f", "Virtual" }
)
VAR __Column1 =
SELECTCOLUMNS ( __Table, "__Column", [crm_call_name] )
VAR __Column2 =
SELECTCOLUMNS ( __Table, "__Column", [crmf_hcp_id] )
RETURN
COUNTROWS ( DISTINCT ( UNION ( __Column1, __Column2 ) ) )
MyMeasure =
VAR __Table =
FILTER (
'eda_edetailing_slides_used',
NOT ( ISBLANK ( [drmf_clm_presentation_slide_id] ) )
&& eda_edetailing_slides_used[activity_type_1] IN { "f2f", "Virtual" }
)
VAR __Column1 =
SELECTCOLUMNS ( __Table, "__Column", [crm_call_name] )
VAR __Column2 =
SELECTCOLUMNS ( __Table, "__Column", [crmf_hcp_id] )
RETURN
COUNTROWS ( DISTINCT ( UNION ( __Column1, __Column2 ) ) )
The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now!
| User | Count |
|---|---|
| 38 | |
| 38 | |
| 37 | |
| 28 | |
| 28 |
| User | Count |
|---|---|
| 124 | |
| 89 | |
| 73 | |
| 66 | |
| 65 |