Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Hi, I would like to make a DAX formula or something that will help me count or sum up everytime a new projec gets added to each of these sections. Everything is under one column when the data is imported so if I count all of column 1 if takes iinto consideration all the extra stuff when I only need to count the yellow stuff and every time one get added to that section
Solved! Go to Solution.
Hi @Anonymous
First we need to define each section.
Let to say you have three sections in this column--"Power","O&G",'Tanks",
Open Edit queries,
Add a conditional column
Fill down for "Custom" column
Close&&apply
Create a measure
Measure = CALCULATE(DISTINCTCOUNT(Sheet2[column1]),FILTER(ALLEXCEPT(Sheet2,Sheet2[Custom]),[column1]<>BLANK()))-1
Best Regards
Maggie
Community Support Team _ Maggie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi @Anonymous
First we need to define each section.
Let to say you have three sections in this column--"Power","O&G",'Tanks",
Open Edit queries,
Add a conditional column
Fill down for "Custom" column
Close&&apply
Create a measure
Measure = CALCULATE(DISTINCTCOUNT(Sheet2[column1]),FILTER(ALLEXCEPT(Sheet2,Sheet2[Custom]),[column1]<>BLANK()))-1
Best Regards
Maggie
Community Support Team _ Maggie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
User | Count |
---|---|
125 | |
106 | |
99 | |
63 | |
62 |
User | Count |
---|---|
135 | |
116 | |
101 | |
71 | |
61 |