Join us for an expert-led overview of the tools and concepts you'll need to pass exam PL-300. The first session starts on June 11th. See you there!
Get registeredPower BI is turning 10! Let’s celebrate together with dataviz contests, interactive sessions, and giveaways. Register now.
Hello I need to create a DAX formula but I can't have a good resutlt .
I need to have a SUM with filter divide by Count with filter it's possible ?
Solved! Go to Solution.
@Vanessa250919
Did not get it completely but try this modified version:
Measuretest =
DIVIDE (
CALCULATE (
SUM ( MASTERTABLE[FNGF_VOLUME_ORG] ),
MASTERTABLE[FNGF_VOLUME_ORG] <> 0
),
CALCULATE (
COUNT ( MASTERTABLE[DAY_DATE] ),
pivot[FNGF_VOL_ORG] <> 0
)
)
⭕ Subscribe and learn Power BI from these videos
⚪ Website ⚪ LinkedIn ⚪ PBI User Group
@Vanessa250919 Should be possible but not really enough to go on. Are you getting a problem with the formula? Is your relationship between mastertable and pivot present and in the right direction?
@Vanessa250919
Did not get it completely but try this modified version:
Measuretest =
DIVIDE (
CALCULATE (
SUM ( MASTERTABLE[FNGF_VOLUME_ORG] ),
MASTERTABLE[FNGF_VOLUME_ORG] <> 0
),
CALCULATE (
COUNT ( MASTERTABLE[DAY_DATE] ),
pivot[FNGF_VOL_ORG] <> 0
)
)
⭕ Subscribe and learn Power BI from these videos
⚪ Website ⚪ LinkedIn ⚪ PBI User Group
User | Count |
---|---|
18 | |
18 | |
14 | |
14 | |
13 |
User | Count |
---|---|
17 | |
14 | |
11 | |
10 | |
8 |