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 Guys,
Newbie here.
I have a dataset with a column that contains different numbers and a measure that having the formula below.
Solved! Go to Solution.
Nevermind, just found a meassure you can use.
you just need to add the filter funktion to your calculation.
Nevermind, just found a meassure you can use.
you just need to add the filter funktion to your calculation.
Yeah it is gonna work however, if im gonna add another calculation on the measure like this one
Not sure how to fix your meassure. I am guessing when doing calculation, it will disregard some filters.
However, here is a workaround for this specific issue.
Instead of making a calculation were you filter down to only count those that equals 5. You can set the filter on the Matrix itself.
Then the Matrix will also concider any other filters you have.
Hope this will help. 🙂
Can you share cal for Total Agents and table realtion diagram
There is only 1 column
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 |
---|---|
114 | |
99 | |
83 | |
70 | |
60 |
User | Count |
---|---|
150 | |
115 | |
104 | |
89 | |
65 |