How to get the measure total at row level for another measure calculation in DAX?

Advertisement

Hi There,
Using DAX, I am trying to get an expression for a calculated measure as follow:
So basically, I would like to get the AMeasure total highlighted in yellow in the A2Measure calculation:
Smeasure -(Ameasure total * WMeasure) where Ameasure total is the one highlighted. 
I think my question would be how to get the total of a measure in order to used in the calculation of another measure.
Thanks and best regards,
Joss

Advertisement

Hi Joss83,
If you're trying to get the result for [AMeasure] at the total level (i.e. 5.09 in your example) you can do this by creating a version of this measures that is evaluated after ignoring the filters (indirectly or explicitly) placed on
the 'Customer' and 'Player' columns. You may also need to ignore the filters place on some other tables or columns that must be ignored in order for the correct total to be returned.
Without knowing much more about your data model, I can only take a vague guess as to what this calculation would look like in your scenario:
AMeasureTotal:=
CALCULATE(
[AMeasure],
ALL(Customer[Customer]),
ALL(Player[Player])
You can read more about the 'ALL' DAX function here:
http://technet.microsoft.com/en-us/library/ee634802.aspx
Hope this helps,
Michael

November 30, -0001

How to get the measure total at row level for another measure calculation in DAX?

Hi There, Using DAX, I am trying to get an expression for a calculated measure as follow: So basically, I would like to get the AMeasure total highlighted in yellow in the A2Measure calculation: Smeasure -(Ameasure total * WMeasure) where Ameasure to

How to get the sum total of just one row in the dashboard

How do I get the sum total of one row in the compound layer results. This is 11g Does anyone know? may be sales, I need the total at the bottom of the row.. thx ChuckI fnd the answer, in the table view, click edit then nxt to the columns and measures

How to get the max total sale by date on every store

I am trying to write a query in Oracle which will return both the store_id and the maximum total sale by dateHi, Whenever you have a question, please post a little sample data (CREATE TABLE and INSERT statements, relevant columns only) for all the ta

How to get the value in one JSP page to another?

Hi, I have problems in passing the value around in JSP. I have two JSP pages as below: test1.jsp I try to get the vaule from my textbox by using: String strUser = request.getParameter ("strUserName"); Then i print out by using: out.print(strUser

How to get the desired total of Random numbers ?

I m in a big problem and want a urgent solution. I want to randomise numbers with specified limit and the total of all the randomised numbers should be desirable. e.g. if i m generating random number 24 times in a loop then the total of all the geren

How to get the link of already archived document

Dear all, How to get the link of already archivied document. for example i have a sales order for which subsequent documents have been archived. now i want to get the link of subsequent document. please give some solution Thanks in advance Thanks, He

HT4061 how go get the missed iphon's imei number

i lose my i phone i dont know iemi number how to get the mised iphones imei numberRead here for the various ways: http://support.apple.com/kb/HT4061 Your carrier also has a record of your phone's IMEI number.Read other 2 answers

How to get the number of the row added to tabular form by the AddRow()

using 4.0. User clicks an Add button which calls a javascript function that gets a couple page item values, inserts a row (addRow(), and updates columns in that newly inserted row with the values from the page items. This works fine if I hard code th

How to get the total number of pages printed in a report?

Hi All, I have a requirement where I need to print a frame of fields only in the last page. Unfortunately I cannot use the 'Print Object On' property as it doesnt work in my case. So, I am planning to write a format trigger on the frame to return TRU

How to get the TableRow from TableView with given row Index.

Hi , I want to retrieve the TableRow object or Cells of that row of the TableView, for the given row index. How i can get that. Here is the below code what i am actually looking for TableView table = new TableView(); table.getSelectionModel().selecte

How to get the size of the webpage?

I am designing a program to analyse the webpage content. wondering how to get the size of the webpage including its image's size and etc. Thanks in advance.As i know , the getContentLength just return then number of characters of its HTML code. By kn

I use iPhoto and want to know how to get the 'key photo' i select on my MacBook Pro to be the one that gets used on my iPhone when i sync them. Any ideas? also, i want the events to appear in the order i choose on my MacBook too

I use iPhoto and want to know how to get the 'key photo' i select on my McBook Pro to be the same one that gets used on my iPhone 5s when i sync. i also want the events to appear on the iPhone in the same order i have them on my macbook. any ideas th

How to get the Vertical scale of Osilloscope TDS 420A ?

Hellow! Anyone can tell me how to get the Vertical scale of TDS 420A? i use "TKTDS read waveform.VI" to show the waveform in a Waveform indicator,but the Vertical scale is not the same as the osilloscope. Thanks!Hi happybird, I installed the TKT

How to get the Dynamic UI component value from JSFF page to any managedbean

HI , We have list of bean objects in jSF page we are iterating the list of bean using the forEach loop and displaying the value into Input type text (UI component) value filed . If we try to get the UI component value in Managed bean we are not getti

Programming help - how to get the read-only state of PDF file is windows explorer preview is ON?

Programming help - how to get the read-only state of PDF file is windows explorer preview is ON? I'm developing an application where a file is need to be saved as pdf. But, if there is already a pdf file with same name in the specified directory, I w

WD ABAP: How to get the contents of selected table lines?

Hi, I'm trying to figure out how to get the contents of table lines back from the UI. I display a table with several lines of data. The user selects some rows. I want to move the contents of the selected rows to another table. I have a context attrib

HOw to Get the top level of Hierarchy and count on that basis

hi i have following tables desc hr_organizations_units_V organization_id PRIMARY KEY name ORGANIZATION_type per_org_structure_elements organization_id_parent FK TO hr_organizations_units_V(ORGANIZATION_ID) organization_id_child FK TO hr_organizations

How to get the selectedIndex from a combobox made by classFactory?

Dear All, I am trying to get the selectedIndex or selecetedItem.banda_id when changing a combobox that is created by classFactory and it is inside a datagrid. The code I have is: MXML: <mx:DataGrid width="100%" height="100%" id=&quo

I would like to know how to get the unrestricted quantity excluding actual customer ordr quantities on a given group of items?

I would like to know how to get the unrestricted quantity excluding actual customer ordr quantities on a given group of items?Hi , Welcome to the HP Forums! It is a terrific place to find answers and tips! For you to have the best experience in the H

How to get the Ship Country?

Hi, Assume I already have the invoice number, and company code(there is only one item in the invoice), how to get the ship country? I have the following logic to read it. 1. Get the delivery note Number and Company code. 2. Get Delivery comapny code,