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.
Hi,
I have some key values and some graphs on a dashboard. The graphs show variables over time. I want the key values to show for 2014 when nothing is selected, but when 2013 is selected on a graph, I want the key value to show the 2013 count. I'm very new to Power BI, but I though a measure might be able to do this.
ItemYrN = if(ISCROSSFILTERED('Table1'[Year]),calculate(counta('Table1'[Item])),calculate(counta('Table1'[Item]),filter('Table1','Table1'[Year]=2014)))
Item is a string field.
I have tried many other variations of this but just can't seem to make it work. How do I get the equation to count the crossfiltered data when ISCROSSFILTERED results in true?
Or any other suggestions to achieve what I want would be helpful.
Many thanks,
D
Solved! Go to Solution.
I *think* what you want to do is to use ALLSELECTED in your true clause in the Calculate function versus in the false clause use the filter that you have. Then, the true portion should honor the filters that have been selected but when it is not crossfiltered, then you will get 2014 values.
I *think* what you want to do is to use ALLSELECTED in your true clause in the Calculate function versus in the false clause use the filter that you have. Then, the true portion should honor the filters that have been selected but when it is not crossfiltered, then you will get 2014 values.
Thank you!! That works perfectly!!!!
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 |
---|---|
111 | |
100 | |
80 | |
64 | |
58 |
User | Count |
---|---|
148 | |
111 | |
93 | |
84 | |
66 |