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.
I'm fairly new to BI and DAX, so I'm a bit confused by programming hierarchy.
Here's a link to my sample BI file: https://www.dropbox.com/s/rbjoqspdjdmtquq/Power%20BI%20Forum%20Sample.pbix?dl=0
The following Measure is throwing the error. I want to calculate the sum of a column for all but the very last number. A different column has a count of how many rows are in the column, so I tried to constrain using CALCULATE, but get the error message.
Solved! Go to Solution.
It wasn't, but now it is. Thanks for checking.
In the following screenshots, "Alpha" and "Charlie" are roughly the same (though not exactly for reasons not germaine). Except Alpha is comprised of three assets and Charlie is comprised of one.
The desired outcome is the "Charlie" screenshot below.
The different forumlas are as follows:
Hi @mrothschild,
From your pbix, it seemed your table looks correct with your desired result?
Regards,
Daniel He
It wasn't, but now it is. Thanks for checking.
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 |