- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
New Measure | Not behaving Accordingly?
To make sure I am on the correct table I clicked on the synopsis (...) right beside the table name I want to create a measure on... but when I did this "New Measure Column Name" = FORMAT( - and when I tried to type the fields in that table or the full name 'Table Name'[Field Name'] nothing appears... But other tables are doing fine...
And by the way if I do a New Column it does detect the fields of that table?
I'm not sure what is going on here... I already deleted the table and reuploaded into PBI but the same thing is happening.
Solved! Go to Solution.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Anytime you create Measures you need to aggregate the columns you want to reference.
What is happenning is - Intellisense is helping you by not letting you select a Column without you aggregating it somehow first!
Look at this example...
Measure with FORMAT = FORMAT ( SUM ( Table[Gross] ) - SUM ( Table[Tax] ) - SUM ( Table[Deductions] ), "Currency" )
When you create a Column because it will be evaluated on every row there's no need for aggregation
(you can of course aggregate also depending on what you want the result to be)
Hope this helps!
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Okay I think it's the FORMAT command - it only works for New Column and not for New Measure... WHY? I'm still trying to find out... unless someone from here would like to help explain this.
Thank you.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Anytime you create Measures you need to aggregate the columns you want to reference.
What is happenning is - Intellisense is helping you by not letting you select a Column without you aggregating it somehow first!
Look at this example...
Measure with FORMAT = FORMAT ( SUM ( Table[Gross] ) - SUM ( Table[Tax] ) - SUM ( Table[Deductions] ), "Currency" )
When you create a Column because it will be evaluated on every row there's no need for aggregation
(you can of course aggregate also depending on what you want the result to be)
Hope this helps!

Helpful resources
Subject | Author | Posted | |
---|---|---|---|
05-16-2024 07:52 AM | |||
08-05-2024 02:18 AM | |||
03-26-2021 09:10 AM | |||
01-15-2024 10:17 PM | |||
11-03-2024 10:32 PM |
User | Count |
---|---|
138 | |
107 | |
84 | |
60 | |
46 |