Check your eligibility for this 50% exam voucher offer and join us for free live learning sessions to get prepared for Exam DP-700.
Get StartedDon't miss out! 2025 Microsoft Fabric Community Conference, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount. Prices go up February 11th. Register now.
Hello,
I am trying to display one specific calculation group item but I am constantly receiving the same output, which is blank value. Whereas the total appears as '1':
This is the formula that is being used as a Value in the matrix:
Whereas this is the calculation element that is being used as column in the matrix:
I think that the key is in the 'ALLSELECTED()' part of the 'CALCULATE' but it seems to not work.
Please I need support on this asap. Thank you very much in advance!
@JasserBI , Grand Total will be 1, as the sum of the numerator is the same as denominator in total (for sum measure).
You can use all, and that will give a difference only when something is filtered.
The information you have provided is not making the problem clear to me. Can you please explain with an example.
Appreciate your Kudos.
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!
Check out the January 2025 Power BI update to learn about new features in Reporting, Modeling, and Data Connectivity.
User | Count |
---|---|
97 | |
65 | |
45 | |
39 | |
31 |
User | Count |
---|---|
164 | |
111 | |
61 | |
53 | |
38 |