Using Measures in Columns: one approach works; one does not

Anything related to PowerPivot and DAX Formuale
WilliamHarper
Posts: 8
Joined: Fri Jun 19, 2020 6:26 am

Using Measures in Columns: one approach works; one does not

Postby WilliamHarper » Sun Aug 30, 2020 4:45 am

My 1st post here & hope what I am submitting makes sense. See small attached .pbix and I think this will become more clear.

Why do the adjusted x, y columns (xAdjByMeas, yAdjByMeas) that use the measures (xMeasAdj, yMeasAdj) work here? As expected the adjusted x, y columns (xAdjyByWhatIf, yAdjByWhatIf) do not work with What-If measure values (xWhatIfMeas Value, yWhatIfMeas Value)?

I am dealing with x, y data used in scatter plots. Users currently adjust the data by a multiplicative factor that applies to all of x or all of y in a column. Currently they change in Power BI Desktop a column to do this which works fine. But I have two example adjustments using measures: one works; one does not. I understand why one does not work, but do not understand why the other works.

Thanks,

Bill Harper, william.harper@dnvgl.com
Attachments
Simple Example on Columns with measures.pbix
very simple illustration of issue
(40.13 KiB) Downloaded 23 times

Return to “PowerPivot/DAX”

Who is online

Users browsing this forum: No registered users and 2 guests