Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Hey guys,
Thanks already for the effort for answering my question.
I created a measure "HEADCOUNTM" and I want to use this measure within this measure :
Solved! Go to Solution.
Try change the HEADCOUNTM to the following, by the you wnt SUM or Count?
HEADCOUNTM = Calcuate(sum([Active]),
Filter(PA0000,
Then stick with your orginial formula as below:
Try change the HEADCOUNTM to the following, by the you wnt SUM or Count?
HEADCOUNTM = Calcuate(sum([Active]),
Filter(PA0000,
Then stick with your orginial formula as below:
Thanks a lot for your effort even though this is not solving the problem.
If I just copy paste your code, I'm getting an error 🙂
"A single value for column PERSG in table "PA0001" cannot be determined. This can happen when a measure formula refers to a column that contains many values without specifying an aggregation such as min, max, count or sum to get a single result.
Thanks again,
KR,
Stef
Hi @Pragati11 ,
Measure HEADCOUNTM =
Hi @StefRenneboog91 ,
If I see your HEADCOUNTM measure, it is calculated at a row level and in the other DAX above you are using this measure without any summarisation like MAX, MIN, etc. as it will return multiple values.
So, in your DAX where you are getting error, use an aggregation funtion on your HEADCOUNTM measure and then try it.
Hi @Pragati11 ,
This is my code at this moment :
Hi @StefRenneboog91 ,
Use this aggregation with the modification I suggested earlier to your DAX:
NoIT1 =
CALCULATE (
DISTINCTCOUNT ( PA0000[PERNR] ),
FILTER (
ALL ( PA0000 ),
PA0000[BEGDA] <= TODAY ()
&& PA0000[ENDDA] >= TODAY ()
&& ( PA0001[PERSG] = 1
|| PA0001[PERSG] = 2
|| PA0001[PERSG] = 4 )
&& PA0000[IT1] = 0
&& MIN(HEADCOUNTM) = 1
)
)
Hi @StefRenneboog91 ,
Try modifying your DAX as follows:
User | Count |
---|---|
140 | |
113 | |
104 | |
77 | |
65 |
User | Count |
---|---|
136 | |
118 | |
101 | |
71 | |
61 |