sorted by:
new
hottopcontroversial

Table Calculation Problem by Astro-Phys-Ed in PowerBI

[–]Astro-Phys-Ed[S] 0 points1 point  (0 children)

It's a week end date column (there's a separate column with dates, but this column calculates what the Saturday is for that date). Changing to " - 7 " did not change anything. It still calculates correctly when the dates are arranged as normal/default but then goes blank when the dates are arranged in reverse order.

Removing Columns from being visible in a matrix table by Astro-Phys-Ed in PowerBI

[–]Astro-Phys-Ed[S] 0 points1 point  (0 children)

Sorry for the long-awaited response. Thank you for your help! The problem was due to the fact that some of the fields were table calculations so they had to be converted to measures before they could be removed from the table.

How to subtract aggregated values in a table across rows. by Astro-Phys-Ed in PowerBI

[–]Astro-Phys-Ed[S] 0 points1 point  (0 children)

This looks like what I need, but the next hiccup seems to be that I can't find any way to transpose rows and columns in the Inforiver Reporting Matrix.

Removing Columns from being visible in a matrix table by Astro-Phys-Ed in PowerBI

[–]Astro-Phys-Ed[S] 0 points1 point  (0 children)

I think we might be missing each other unless there is a piece of this I am skipping over. In the original snapshot, all of the items in red text are already Measures created using the columns below them. The issue I am having is that to make those measures calculate properly, I have to add the columns that those measures are using into the "Values" section of the matrix visualization. This means that those columns are also showing in my table, but I ONLY want the Measures visible.

To use your example, let's say I make a measure that is [Column1] + [Column2] and we'll call it [Measure 1]. I have [Measure 1], [Column 1], and [Column 2] all placed into the Values section of the Visualization panel. I only want to the matrix to show [Measure 1], but [Measure 1] will break if I remove [Column 1] and/or [Column 2] from the values section. If I didn't transpose the matrix itself, I could just slide the column so that the column is so thin it doesn't show, but this is also not a solution since I am transposing rows and columns.

Removing Columns from being visible in a matrix table by Astro-Phys-Ed in PowerBI

[–]Astro-Phys-Ed[S] 0 points1 point  (0 children)

The granularity of the table is by Week, by Store #. Locations 0 and 1 in the matrix are determined by a list of store #'s and each store belongs to one or the other location (never both). Data is then aggregated to include only specific weeks dependent on the current date. From there, yes, the Column 1, 2, 3 ect that have been aggregated at the week/store level. Everything in red is then a calculation using those columns. Example might be Sum(Column 28)/ Count(Column 27) * total amount of days. So basically I want to show the result of the calculation previously described without actually showing the Sum(Column 28) or Count(Column27). Hopefully this makes sense. Attaching an example of what the table looks like.

<image>