DAX Exercise for fun 😁 Part 2

DAX DAX Calculations
21

@Hemantsingh ,

Wow, crazy mind meld! If you look back at my without and with context transition submissions, we took the exact same approach both times.

Really interesting how many different ways there were to solve this. And collectively we found all of them (except the one Antriksh wanted :stuck_out_tongue_closed_eyes: ).

  • Brian
3 Likes
22

“Pick a number between 1 & 10”

“7”

“Sorry, wrong answer, I was thinking of 9” :rofl: :joy:

23

@AntrikshSharma ,

OK, question about that …

I’ve never used GENERATE before, but why don’t the second and third queries return the same result?

Snag_69f9271c

Snag_69f96713
Snag_69f96713657×518 12.7 KB

Snag_69f98dd5
Snag_69f98dd5711×787 17.9 KB

???

Thanks.

  • Brian
1 Like
24

There’s the magic of Context transition in action for you. LOL

A manually defined list, doesn’t have a relationship with columns in the Data table so it will populate a value for each item in the custom list.

@BrianJ create a 4th version and see if you can use TREATAS to bring that back virtually (can hardly wait for the result…)

Also looking forward to a much more detailed and clear explanation by @AntrikshSharma

3 Likes
25

@Melissa Nothing left for me to say, You have answered it!!

3 Likes
26

HI @AntrikshSharma,

Jumping very late even thought I had downloaded the pbix file same day. Here is my solution.

Summary 
Table = 
GENERATE(
    DISTINCT( Data[index] ),
    UNION( 
        CALCULATETABLE( DISTINCT( Data[Col 1] ) ),
        CALCULATETABLE( DISTINCT( Data[Col 2] ))
    )
)

Thanks
Mukesh

1 Like
27

Thanks for starting this discussion @AntrikshSharma and to all contributors on this post. We appreciate everyone who participated and shared in this exercise.

We are tagging this post as “Solved” due to the inactivity if the thread. For further contributions related to this post, please make a new thread.