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
Ran into a strange problem with creating measures and using DAX.
I created measures that count totals of "OK" in columns. I then created a measure out of those measures to get the total number of "OK" from left to right in the data table. (Will add screenshot).
The problem I'm running into is that for some rows it is calculating the "OK" properly, and for others it is not. For example, it's calculating only one "OK" but You can clearly see that there are more.
What confuses me is that if there is a problem in the formula it should show problems in other calculations or other row calculations but it's not doing that and a lot of rows are displayed correctly.
The DAX in the measures:
Solved! Go to Solution.
Ok so learning every day.
It turns out that my initial calculation and measure actually worked on a visual.
It broke in my table visual which was confusing but I figured it out. The reason was that I had too few measures in the table. When I added more or added my calculated measures that I shared in previous posts = everything worked.
So the formula:
Hi @awakened ,
For me, the definition you have for TOTAL OK count measure doesn't make sense, can you give us the real DAX expression?
I add 22 measures together.
Hi:
This is a little tedious but can work. This example is for counting yes.
You have more combinations, so accounting for all of these will just take some extra planning.
You can also unpivot all those yes columns so all the answers (OK) are stacked and then it is much easier to sum up that column.
I hope this helps.
Thanks.
Already went for the unpivot column solution. Doing my best to make it work. If it doesn't will try Your solution.
Great, please let me know if it ecomes your solution! Thanks..
Ok so learning every day.
It turns out that my initial calculation and measure actually worked on a visual.
It broke in my table visual which was confusing but I figured it out. The reason was that I had too few measures in the table. When I added more or added my calculated measures that I shared in previous posts = everything worked.
So the formula:
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 |
---|---|
56 | |
27 | |
24 | |
14 | |
9 |
User | Count |
---|---|
77 | |
61 | |
47 | |
17 | |
12 |