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.
Hello,
I am trying to write a measure to use as a filter on a table/matrix visual. The purpose of the filter is to filter the visual, if i have selected a value in another visual. But if i have nothing selected i want to show all the item_no where the "post_month_year (sale)" is blank.
This is the measure i have so far:
test2 =
SWITCH (
TRUE (),
VALUES ( Vareposter_combined[Post_month_year (purchase)] )
= MAX ( 'Post_month_year (Purchase)'[Post_month_year (purchase)] )
&& VALUES ( Vareposter_combined[Post_month_Year (sale)] )
>= MAX ( 'Post_month_year (Sale)'[Post_month_Year (sale)] ), 1,
ISBLANK ( VALUES ( Vareposter_combined[Post_month_year (sale)] ) ), 1,
NOT ( ISFILTERED ( Vareposter_combined[Post_month_year (purchase)] ) ), 1,
0
)
I use the measure like this:
Hi @skanord
Not sure what's your data. Based on your description, you can create a measure returns 1 when you select a value in another visual, else if you have nothing selected, then it shows all item_no where the "post_month_year (sale)" is blank.
If you need more help, could you provide
(1) a sample file, you can replace raw data with bogus data to protect your privacy,
(2) or provide some samp data involved in the measure
(3) give your expected result based on the sample you provide
Thanks.
Best Regards,
Community Support Team _Tang
If this post helps, 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 |
---|---|
55 | |
25 | |
23 | |
14 | |
11 |
User | Count |
---|---|
78 | |
63 | |
47 | |
17 | |
12 |