Dynamic Hierarchy Title

[BrianJ]

@JoaoMonteiro,

As usual, @Greg is spot on in his assessment. With there being no inherent context in a card visual, you will need to build that context using virtual tables. Here are a number of posts I’ve made on this very topic that hopefully should help you work through a solution.

If not, please do post a PBIX file for a more specific solution.

– Brian

Dax calculation to sum based on criteria

@jprlimey, It’s all about evaluation context. When you drop the measure in the table, the context over which it is evaluating is clear (Review No). However, in a card there is no evaluation context. In case with insufficient evaluation context, DAX will do it’s best to guess, which is why sometimes you get a right answer, sometimes a wrong answer and sometimes a blank, which is DAX’s equivalent of ¯\_(ツ)_/¯. Thus, for these cards (and for the total row of the table for the Lvl 5 measure), …

Using "All-in" Date Harvest Approach with Cards

I received the following interesting question regarding the Date Harvest Deep Dive video I did recently for the Enterprise DNA TV YouTube channel as part of the ongoing time intelligence series that @Melissa and I have been doing: [image] Billy is correct that the approach certainly is easier when you have an explicit evaluation context on date in the visual. However, for visuals that don’t contain this explicit evaluation context (e.g., cards, gauges, etc.), the approach absolutely still wor…

Preventing a measure from summing up in KPI card

@Ikay, Cards can be challenging, because unlike tables, matrixes or charts, they don’t provide any inherent evaluation context. Thus, in situations like this you need to build the proper evaluation context into your measure in the form of a virtual table against which your measure can be evaluated. This post explains the issue in depth with an example. The same approach should be directly applicable to your problem. I hope this is helpful. If you need additional specific guidance, please po…

PS – looking through these posts and seeing how frequently this question does come up, I’m going to put together a YouTube video on this issue – look for it to post later this month…