- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
A field parameter produce wrong percentage values when nested in matrix rows
I have a Power BI report (modeled using a star schema) in which I have created:
1) a field parameter, with eight different data fields;
2) a calculation group, that contains the following time calculation items:
a) Current year values (= "CY")
b) The running-sum values of the current year values (= "CY Cumulate")
c) The percentage of the different current year values against the total value of the current year (= "CY Vertical %")
In Report View I have created:
1) a multi-selection slicer with the field parameter;
2) a single-selection slicer with the year field;
3) a multi-selection slicer with the calculation items of the calculation group;
4) a matrix visual, having on rows the field parameter, on columns the calculation items and a measure (for example: quantity sold) as value.
The problem arises when I choose:
- two or more fields in the field parameter slicer (shown in the matrix row)s
- "CY Cumulate" or "CY Vertical %" in the slicer.
The problem is the fact that in the intersection between the "CY Cumulate" or"CY Vertical %" columns and the inner field in the rows, the values now are wrong and they wrongly depend on how many outer items in the rows are expanded, while instead their value should always be the same indipendently on how many items are expanded in the rows.
Can you please help me ?
Thanks in advance,
Pietro.
My report in Power BI Report View
Explanation in Excel, with actual wrong values and desired correct values
CY formula
CY Cumulate formula
CY Vertical % formula
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Hi @some_bih ,
the problem is NOT solved.
Correcting the formula for the "CY Cumulate" measure does NOT give the correct values that I show in green color in a previous Excel image. I can still see the same values that are highlighted in yellow in that image.
Someone can help me?
Thanks in advance,
Pietro.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Hi @Pietro_Noli so measure/s works when Quearter is not selected in field parameter slicer?
I notice that you have 8 possible values in field parameter slicer while 6 in measure CY Cumulate, part SWITCH (Quarter and Month are extras?)
Did I answer your question? Mark my post as a solution!
Proud to be a Super User!
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Hi @some_bih ,
you are right: in the "CY Cumulate" measure formula, I'm missing Quarter and Month sections.
The correct formula for the "CY Cumulate" measure formula is in the following image:Correct "CY Cumulate" measure formula
Thanks for your help.
Pietro.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Hi @Pietro_Noli if this help please accept as Solution so other member of community could use it.
Thank you.
Did I answer your question? Mark my post as a solution!
Proud to be a Super User!

Helpful resources
Subject | Author | Posted | |
---|---|---|---|
10-06-2024 07:29 AM | |||
08-16-2024 04:39 AM | |||
07-25-2024 10:02 AM | |||
04-19-2024 10:51 AM | |||
09-13-2024 11:29 AM |
User | Count |
---|---|
14 | |
14 | |
11 | |
11 | |
8 |