Forum Discussion
Sumx is not working with iterative condition
- Anonymous3 years ago
Hi BChinya ,
Please try:Number of subjects within = VAR _Binsize_min = SELECTEDVALUE ( 'Bin Start'[Bin Start] ) VAR _binsize_end = _Binsize_min + SELECTEDVALUE ( 'Bin Size'[Bin Size] ) VAR _subnr = CALCULATE ( COUNTROWS ( DM ), 'DM'[Age] >= _Binsize_min && 'DM'[Age] < _binsize_end, ALLSELECTED ( 'DM'[Subject] ) ) RETURN _subnrOutput:
Best Regards,
Gao
Community Support TeamIf there is any post helps, then please consider Accept it as the solution to help the other members find it more quickly.
If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!How to get your questions answered quickly -- How to provide sample data in the Power BI Forum
Hi BChinya ,
Please try:
Number of subjects within =
VAR _Binsize_min =
SELECTEDVALUE ( 'Bin Start'[Bin Start] )
VAR _binsize_end =
_Binsize_min + SELECTEDVALUE ( 'Bin Size'[Bin Size] )
VAR _subnr =
CALCULATE (
COUNTROWS ( DM ),
'DM'[Age] >= _Binsize_min
&& 'DM'[Age] < _binsize_end,
ALLSELECTED ( 'DM'[Subject] )
)
RETURN
_subnr
Output:
Best Regards,
Gao
Community Support Team
If there is any post helps, then please consider Accept it as the solution to help the other members find it more quickly.
If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!
How to get your questions answered quickly -- How to provide sample data in the Power BI Forum
- BChinya3 years agoFrequent Visitor
Thank you. This works like charm!