The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredCompete to become Power BI Data Viz World Champion! First round ends August 18th. Get started.
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 ?
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
User | Count |
---|---|
24 | |
10 | |
8 | |
7 | |
6 |
User | Count |
---|---|
31 | |
12 | |
10 | |
10 | |
9 |