DAX script
Budget: $30 – $250 USD
Need assistance to complete a short DAX script. It should be easy for a person with solid knowledge. This is NOT using Power BI, but just plain DAX as the query connects to a PBI dataset to consume the data on another report using PBI report builder.
The data is aligned in seven categories, and since it will be utilized by report builder, the lineage must be maintained. In essence, one particular row on the summarized data needs to be populated by the aggregation of the other categories.
We have been able to get the other categories summarized producing the right numbers, but can't figure out how to update the one row that needs it on the report.
The data is aligned in seven categories, and since it will be utilized by report builder, the lineage must be maintained. In essence, one particular row on the summarized data needs to be populated by the aggregation of the other categories.
We have been able to get the other categories summarized producing the right numbers, but can't figure out how to update the one row that needs it on the report.