Two identical visuals with different output - how it's possible?

[Anonymous]

Please Help to understand the difference - have 2 identical visuals with different output - how it's possible?

Download here

FYA

1. How to recreate 2nd (bottom) visual behaviour from 1st  (    top   ) one
2. How to recreate 1st  (    top   ) visual behaviour from 2nd (bottom) one

Related Question

P.S. My Desktop version:

[Greg_Deckler]

@Anonymous Strange part is that I can't recreate the top visual although if I copy and paste it the visual works fine.

[Anonymous]

@Greg_Deckler 
Could you please double check, you can't reccreate the 1st (top) one or 2nd (bottom) one?

Why I am asking: during the session with Microsoft support (TrackingID#2301130050000946) we found out that we can recreate the top one, not the bottom one.

Way to recreate the top visual from bottom one:

1. Drill Up and Expand

Could you please share details, how do you recreate the bottom one?

[Greg_Deckler]

@Anonymous I just created a new visual from scratch and it matched the bottom one.

[Anonymous]

How to recreate 2nd (bottom visual behaviour)

P.S. Updated the initial post with 2 links:

1. How to recreate 2nd (bottom) visual behaviour
2. How to recreate 1st (top) visual behaviour

[Anonymous]

@Greg_Deckler , thank you for your feedback.
At least I don't feel myself now as a crazy man with hallucinations - it's a good news. 🙂

Could you pleasse look to this question in related topic:

[Anonymous]

@Greg_Deckler looked into your youtube channel...

Now it's double interest for me - is it possible to write this rnkDate measure using your NO CALCULATE phylosophy? 🙂

[Greg_Deckler]

@Anonymous Probably, are you just trying to rank your date based upon your Type and subType? 

[Anonymous]

@Greg_Deckler 
I want to rank Date based on all subgroups mentioned in matrix Rows section except Date.
Examples:

So, it means that I want to avoid explicit use of Type and subType columnnames in measures/calculations

P.S.

1. Source file available in  here
2. If you have solution please post it in related topic , so I can accept it

[Greg_Deckler]

@Anonymous Sounds like a use case for ALLEXCEPT?

[Anonymous]

Hi @Greg_Deckler,
Created separate branch for this topic:
https://community.powerbi.com/t5/DAX-Commands-and-Tips/NO-CALCULATE-theory-test1/td-p/3028126