exam questions

Exam DA-100 All Questions

View all questions & answers for the DA-100 exam

Exam DA-100 topic 11 question 1 discussion

Actual exam question from Microsoft's DA-100
Question #: 1
Topic #: 11
[All DA-100 Questions]

DRAG DROP -
You need to create a DAX measure in the data model that only allows users to see projections at the appropriate level of granularity.
How should you complete the measure? To answer, drag the appropriate values to the correct targets. Each value may be used once, more than once, or not at all. You may need to drag the split bar between panes or scroll to view content.
NOTE: Each correct selection is worth one point.
Select and Place:

Show Suggested Answer Hide Answer
Suggested Answer:
Scenario: Revenue projections are set at the monthly level and summed to show projections for the quarter.

Box 1: IF -

Box 2: ISFILTERED -
ISFILTERED returns TRUE when columnName is being filtered directly. If there is no filter on the column or if the filtering happens because a different column in the same table or in a related table is being filtered then the function returns FALSE.

Box 3: SUM -
Reference:
https://docs.microsoft.com/en-us/dax/isfiltered-function-dax

Comments

Chosen Answer:
This is a voting comment (?). It is better to Upvote an existing comment if you don't have anything to add.
Switch to a voting comment New
DeathCaliberKnight
Highly Voted 4 years, 1 month ago
answer is correct
upvoted 33 times
...
NargesRokni
Highly Voted 3 years, 8 months ago
I really didn't understand the wuestion well!
upvoted 17 times
...
Ashley090521
Most Recent 3 years, 3 months ago
on exam 3/1/2022
upvoted 2 times
...
nowwin
3 years, 8 months ago
question in exam on 18th September
upvoted 4 times
Ihueghian
3 years, 8 months ago
Same 16/10
upvoted 1 times
...
...
DeathCaliberKnight
4 years, 1 month ago
we only use keepfilters with calculate functions so yep just saying
upvoted 5 times
Pombo
4 years ago
https://docs.microsoft.com/pt-pt/dax/keepfilters-function-dax
upvoted 2 times
...
...
patsql
4 years, 4 months ago
Shouldn't this formula use SUMX as there is no CALCULATE to iterate?
upvoted 3 times
Harmoniek
4 years, 4 months ago
SUMX uses table name as an argument not just column name as shown in the question
upvoted 6 times
...
...
CDL
4 years, 6 months ago
correct Ans. becoz: 1, if (ABC, abc) -> if ABC is true, then return abc. 2, ISFILTERED --> Returns TRUE when columnName is "being filtered " directly. Table 'Date' is a dimension table, usually proactively acting as a filter to others (eg: group by [Date]) to aggregate "fact" table 's column.
upvoted 3 times
CDL
4 years, 6 months ago
Let me break it down a little bit. We need “not(isfilter(xx)” TRUE, and then ISFILTER must be a FALSE. Which means whatsoever inside the ISFILTER must be a “dimension table”, cannot act as a “fact” table to be filter by others to get some aggregated data (eg: “sum, count, min, max, etc….).
upvoted 5 times
...
...
Lhouss
4 years, 6 months ago
Agree with solution as a calculation at date (day) level doesn't make sense in this context.
upvoted 2 times
...
Talkabout_Me
4 years, 8 months ago
DAX has to make use of some conditionality so as to restrict user view of projections. so the DAX will be IF-------KEEPFILTERS----SUM
upvoted 1 times
sosokii
4 years, 8 months ago
it's ISFILTERED because it will returns boolean (if it's not isfiltered give me the total), KEEP FILTERS returns a table
upvoted 36 times
medenka
4 years, 6 months ago
Isn't it just the very opposite? https://docs.microsoft.com/en-us/power-bi/guidance/dax-avoid-avoid-filter-as-filter-argument
upvoted 1 times
tamin
4 years, 5 months ago
KEEPFILTERS works only with CALCULATE or CALCULATETABLE. So, it has no sense in this DAX. ISFILTERED is correct due to if we are not filtering by Date we suppose the filters are Year, Quarter or Month so, we have to accumulate Revenue Projection
upvoted 4 times
DeathCaliberKnight
4 years, 1 month ago
agreed with tamin
upvoted 1 times
...
...
...
...
...
Community vote distribution
A (35%)
C (25%)
B (20%)
Other
Most Voted
A voting comment increases the vote count for the chosen answer by one.

Upvoting a comment with a selected answer will also increase the vote count towards that answer by one. So if you see a comment that you already agree with, you can upvote it instead of posting a new comment.

SaveCancel
Loading ...