excelguylondon
New Member
- Joined
- Feb 24, 2017
- Messages
- 2
[FONT="]Hi,[/FONT]
[FONT="] [/FONT]
[FONT="]I am trying to create a dax measure by doing the following: -[/FONT]
[FONT="] [/FONT]
[FONT="]1. I have a measure named "Consumed Data" that gives me the amount of data consumed since the start of the month.[/FONT]
[FONT="] [/FONT]
[FONT="]2. I have a city names in a column "City" of table "Location". I want the city to be "London".[/FONT]
[FONT="] [/FONT]
[FONT="]So basically sum of Consumed data (from the measure) where table Location and City is London.[/FONT]
[FONT="] [/FONT]
[FONT="]How do I write the equivalent DAX expression for this to create a measure?[/FONT]
[FONT="]Thanks.[/FONT]
[FONT="] [/FONT]
[FONT="]I am trying to create a dax measure by doing the following: -[/FONT]
[FONT="] [/FONT]
[FONT="]1. I have a measure named "Consumed Data" that gives me the amount of data consumed since the start of the month.[/FONT]
[FONT="] [/FONT]
[FONT="]2. I have a city names in a column "City" of table "Location". I want the city to be "London".[/FONT]
[FONT="] [/FONT]
[FONT="]So basically sum of Consumed data (from the measure) where table Location and City is London.[/FONT]
[FONT="] [/FONT]
[FONT="]How do I write the equivalent DAX expression for this to create a measure?[/FONT]
[FONT="]Thanks.[/FONT]