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 All,
I have created a measure for a dashboard as below :
you said you tried "ALL" which should help you here. Here's a thread which may help on some syntax:
https://community.powerbi.com/t5/Desktop/Make-measure-ignore-specific-filter/td-p/336870
I may be misunderstaing what your saying but could you edit the interactions with your filter and the KPI visual?
Take a look at this visual. I've edited the interactions so that when a value is selected in the filter the only value on the page that gets updated is the 'Column 3' card. You'll see that my table and the 'Column 2' card are no longer being filtered by the 'Column 1' filter. If this is viable solution you'll need to select your filter -> Click the edit interactions button -> and for each visual that you don't want filtered by that filter visual, you'll need to click the icon I have highlighed.
Thank you for the quick response.
In the above scenario, I am not showing the 'Avg' value in a KPI directly but i am using it to calculate other measures as a denominator value.
Output = calculate(count(Data[ID]))/Avg
The 'Avg' value should be constant for all the selected values of the Data[Action] Slicer.
Do you have other filters on the page?
Also, what are you trying to accomplish with the FirstDate and LastDate in your Avg function? Those are being treated as a filter but what are you filtering? I put a simple dataset together with 3 columns (ID, CreatedDate, Action) and that avg calculation stays the same regardless of which action I select.
Can you provide a sample dataset?
Thanks for the Response.
Here is my sample data set and
Avg calculation= (clculate(count(num),firstdate(Startdate)
+ Calculate(count(num),lastdate(statdate))/2
Start Date | Num | Action | Position Number | Division Code |
7/1/2017 | 1 | P | 1 | 23 |
7/2/2017 | 1 | p | 2 | 25 |
7/3/2017 | 2 | TA | 3 | 45 |
7/4/2017 | 2 | TA | 4 | 43 |
7/5/2017 | 3 | T | 5 | 25 |
7/6/2017 | 5 | T | 6 | 26 |
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 |
---|---|
107 | |
100 | |
80 | |
63 | |
58 |
User | Count |
---|---|
148 | |
111 | |
94 | |
84 | |
67 |