measuresac
SAC Story - Measure Value/Text
I have a SAC Story in which i want to display the measure "Availlable Quantity". In Query CDS View i have defined it as query.axis: #ROWS.
When creating the story i see just the EndUserText label on the rows and next to it the values, but i do not understand why the value is not directly visible in the Measure Column.
How can i change this to see the values directly in the Measure Column?
Query View:
@AnalyticsDetails.query.axis: #ROWS
@EndUserText.label: 'Available Qty'
odProb.AvailableQty as AvailableQty,
Cube View:
@DefaultAggregation: #SUM
odProb.AvailableQty as AvailableQty,
Thx in advance!
Solution
Ok this was quick. Just drag and drop the measure into the columm.
Sry.
- Distinct Count Rows with filter on Same column with Multiple Rows
- How to show timeseries data up to selected month in Power BI line chart with a Slicer
- How to use DAX to filter rows based on a date slicer
- Column totals are doubling in Powerbi
- SAC Story - Measure Value/Text
- the latest current/previous week available in DAX
- Using LOOKUPVALUE in DAX measure
- Calculating a measure on all rows based on a subset of the data
- Get length of the longest line segment in SVG using JavaScript
- I have two measures in PowerBi - one that calculates the number and one the percent. How can I concatenate please to show e.g. "3 (3.9%")
- how to color UNICHAR in dax
- Get Earlies & Latest Date per customer - DAX
- How can I check is null in dax?
- Create a Power BI Measure that counts rows based on values in two columns
- Measure to calculate running total per row in PowerBI Matrix
- How to plot duplicate values on a multiple lines chart without summing them up?
- How to create a basic line chart in Power BI?
- How to make CALCULATE measure for last date exists before date in current row?
- PBI - SVG circle isn't displaying
- QTD and YTD in DAX
- Negative zero values - Power BI
- PowerPivot Relationships showing blank rows of data and not calculating the measures correctly
- Using a DAX Count rows / Treatas measure with a subtraction element
- PowerBI Chart of monthly differences with specific month labels
- how to remove zeros after rounding in DAX?
- Dynamically Generate Target in Matrix Using DAX
- Remove a page filter from a drill through
- How to flatten a hierarchy in PowerBI?
- DAX Nesting Multiple IF statements
- How is it possible for DAX syntax to reference the original table name when using table variables?