Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Hi all,
I'd like to create the following scenario:
These are the correct values, but I want to filter the list with records wich only meet the criteria of 'MomenteelLeeg'
I have tried it whith
CALCULATE(
COUNT(fct_Leeg[_Id]);
ALL(fct_Leeg[MomenteelLeeg])
)
But this returns the results below...(shows only last day)
Any suggestions?
Thanks!
Solved! Go to Solution.
@Anonymous ,
You can 'ALL' table instead of 'ALL' a column like pattern below:
Result = CALCULATE ( COUNT ( fct_Leeg[_Id] ); ALL ( fct_Leeg ) )
Community Support Team _ Jimmy Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
@Anonymous ,
You can 'ALL' table instead of 'ALL' a column like pattern below:
Result = CALCULATE ( COUNT ( fct_Leeg[_Id] ); ALL ( fct_Leeg ) )
Community Support Team _ Jimmy Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
@Anonymous ,
If [MomenteelLeeg] is in a slicer, you may modify your measure like pattern below and check if the issue persists:
Result = CALCULATE ( COUNT ( fct_Leeg[_Id] ); ALLSELECTED ( fct_Leeg[MomenteelLeeg] ) )
Community Support Team _ Jimmy Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Alas,
It still doesn't work..
@Anonymous ,
Have you solved your issue by now? If you have, could you please help mark the correct answer to finish the thread? Your contribution will be much appreciated.
Regards,
Jimmy Tao
User | Count |
---|---|
130 | |
108 | |
101 | |
67 | |
62 |
User | Count |
---|---|
137 | |
115 | |
102 | |
71 | |
61 |