Forum Discussion

Atoma's avatar
Atoma
Frequent Visitor
2 years ago

Improved chart reading with Dax formula

Hello everyone,

For a graph, I would like the display to be more list here we have the number of value according to day. I would like it not to be displayed when there are less than 5 values per day. The aim is to have a trend.

 

I have try with this Dax formula : 

// Colonne calculée
NombreParJour =
CALCULATE(
COUNT('Issues (Central Malley – Aire B)'[Area]),
ALLEXCEPT('Issues (Central Malley – Aire B)', 'Issues (Central Malley – Aire B)'[Created].[Jour])
)

// Mesure
CompteurValeurFiltre =
IF(
MAX('Issues (Central Malley – Aire B)'[NombreParJour]) < 10,
BLANK(),
COUNT('Issues (Central Malley – Aire B)'[Area])
)

 

Can You help me ?

1 Reply

  • Anonymous's avatar
    Anonymous
    Not applicable

    Hi Atoma ,

     

    Can you provide some test data about above formula, I'll get back to you as soon as I can.

     

    Adamk Kong,

    Best regards