Nested scorecard - how to automatically show a status at the main level

[DaniloTavecchio]

Hi all,

I have to group three different scorecard: one is a percentage , one is a value and another one is a check against a fork. Each of these three scorecards refers to a report in a premium PBI Service.

What I like is to set a rule at the main level, the so called "father", that set it status as green (ok) only if all the three sub-scorecard are green. 

When I try to use the subscorecard I can only use math functions (SUM AVG MIN) and not a reference to the status of them. Since the three sub-scorecards are completely different measures I'd rather like to have something simple: all the sub-scorecard are "green" ? Fine ! That's it! eveything's fine ! Put "KPI Master EBDS" as green, otherwise red.

any help?

[ribisht17]

HI @DaniloTavecchio ,

Please check Announcing: Enterprise scorecards with hierarchies and linked metrics in Power BI Metrics | Microsof... 

Regards,

Ritesh

Community Champion

Please mark the answer if helpful so that it can help others

Dance-Sing with Data Projects - YouTube

View solution in original post

[DaniloTavecchio]

Hi Ritesh,

Yes, I saw that documents of course. Unfortunately does not cover my needs. As you can see it shows nested scorecards all with the same kind of measure ...

... so it's easy to sum three values (451, 620, 530) and create a new mathematical rule upon that SUM: is it above 1,61M? That's fine, GREEN!

This is not what I'm looking for: I'd like to have "grow revenue for northwind" GREEN if the three sub-scorecards are green (*) no matter at all the logic or the calculations they're doing .

Why?

a) because if I have to change rules in one of the sub-scorecard I do not want to change rules in the father level

b) because, as in my case, I could have different KPI (KQI) type that I cannot use SUM, MIN, MAX, AVG

(*) I guess grouping only the same kind of scorecard (all values, all money, all percentage etc.) is one solution but before that I'm asking here 

[v-achippa · Accepted solution]

Hi @DaniloTavecchio,

Thank you for reaching out to Microsoft Fabric Community.

Currently power bi metrics does not let parent metric inherit the green or any other status of its children directly. The parent can only aggregate a numerical value field. So use a DAX measure in your dataset that gives the output as 1 when every child is green and 0 otherwise and bind the parent metric’s value to that measure.

If this post helps, then please consider Accepting as solution to help the other members find it more quickly, don't forget to give a "Kudos" – I’d truly appreciate it! 

Thanks and regards,

Anjan Kumar Chippa

[DaniloTavecchio]

Hi, that is what I was afraid to be confirmed. I find the scorecard has been builted with a quite complex logoc of calculations and rules outside of the data model. Pro and cons but I like the pros. To create measures in the dataset make sense and is for sure a solution now but :

1) I guess the simple RAG status logic inherited from the level below could be appreciated

2) afaik scorecard are set in PBI service, where basic or even less IT skills can operate so, using DAX, is imho loosing the potential of the scorecards.

Like I said thanks a lot for the reply

Danilo