Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hello, I created a group by table in dax, it's possible to add a filter ? I need for all average to filter 0 vallue .
Thanks
Solved! Go to Solution.
Hey @Vanessa250919 ,
sure, you can use the FILTER function to filter the group by table:
FILTER
GROUPBY (
MASTERTABLE,
MASTERTABLE[POSTAL_CODE],MASTERTABLE[DIENST], MASTERTABLE[Key],
"PAK_VOL_REEL",AVERAGEx(CURRENTGROUP(),MASTERTABLE[PAK_VOLUME_REEL]),
"PAK_VOL_ORG",AVERAGEX(CURRENTGROUP(),MASTERTABLE[PAK_VOLUME_ORG]),
"EE_VOL_ORG",AVERAGEX(CURRENTGROUP(),MASTERTABLE[EE_INDIV_ORG]),
"EE_VOL_REEL",AVERAGEX(CURRENTGROUP(),MASTERTABLE[EE_INDIV_REEL]),
"ENA_VOL_ORG",AVERAGEX(CURRENTGROUP(),MASTERTABLE[ENA_VOLUME_ORG]),
"ENA_VOL_REEL",AVERAGEX(CURRENTGROUP(),MASTERTABLE[ENA_VOLUME_REEL]),
"FNGF_VOL_ORG",AVERAGEX(CURRENTGROUP(),MASTERTABLE[FNGF_VOLUME_ORG]),
"FNGF_VOL_REEL",AVERAGEX(CURRENTGROUP(),MASTERTABLE[FNGF_VOLUME_REEL]),
"KRANT_VOL_ORG",AVERAGEX(CURRENTGROUP(),MASTERTABLE[KRANT_VOLUME_ORG]),
"KRANT_VOL_REEL",AVERAGEX(CURRENTGROUP(),MASTERTABLE[KRANT_VOLUME_REEL])
),
[ENA_VOL_REEL] > 0 && [KRANT_VOL_REEL] > 0
)
Hey @Vanessa250919 ,
sure, you can use the FILTER function to filter the group by table:
FILTER
GROUPBY (
MASTERTABLE,
MASTERTABLE[POSTAL_CODE],MASTERTABLE[DIENST], MASTERTABLE[Key],
"PAK_VOL_REEL",AVERAGEx(CURRENTGROUP(),MASTERTABLE[PAK_VOLUME_REEL]),
"PAK_VOL_ORG",AVERAGEX(CURRENTGROUP(),MASTERTABLE[PAK_VOLUME_ORG]),
"EE_VOL_ORG",AVERAGEX(CURRENTGROUP(),MASTERTABLE[EE_INDIV_ORG]),
"EE_VOL_REEL",AVERAGEX(CURRENTGROUP(),MASTERTABLE[EE_INDIV_REEL]),
"ENA_VOL_ORG",AVERAGEX(CURRENTGROUP(),MASTERTABLE[ENA_VOLUME_ORG]),
"ENA_VOL_REEL",AVERAGEX(CURRENTGROUP(),MASTERTABLE[ENA_VOLUME_REEL]),
"FNGF_VOL_ORG",AVERAGEX(CURRENTGROUP(),MASTERTABLE[FNGF_VOLUME_ORG]),
"FNGF_VOL_REEL",AVERAGEX(CURRENTGROUP(),MASTERTABLE[FNGF_VOLUME_REEL]),
"KRANT_VOL_ORG",AVERAGEX(CURRENTGROUP(),MASTERTABLE[KRANT_VOLUME_ORG]),
"KRANT_VOL_REEL",AVERAGEX(CURRENTGROUP(),MASTERTABLE[KRANT_VOLUME_REEL])
),
[ENA_VOL_REEL] > 0 && [KRANT_VOL_REEL] > 0
)
Hello @selimovd , I tryed to make a filter like this :
But I have always a 0 values
Hey @Vanessa250919 ,
in your measure you didn't filter for [PAK_VOL_REEL] > 0, so it will also show the 0 values for that Group by column.
I can't tell you why the values are 0 as you didn't share any data with us.
Does that make sense?
Best regards
Denis
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
42 | |
21 | |
21 | |
14 | |
13 |
User | Count |
---|---|
43 | |
39 | |
33 | |
18 | |
17 |