Forum Discussion
Calculate sum issue : X projects = 0 charges
Try this new version. Something complicated was going on. The result is now 4 for the mentioned case:
N-projets non-chargés V4 = COUNTROWS ( FILTER ( CALCULATETABLE ( DISTINCT ( 'Charges'[N_Projet] ), Charges[Itération_PdC] = "S2-2020" ), CALCULATE ( SUM ( Charges[Charges] ) = 0 ) ) )Please mark the resolved question when you are finished and consider giving a thumbs up if the posts are useful.
Contact me privately for assistance with any large-scale BI needs, tutoring, etc.
Bless you
I'm sorry I couldn't answer sooner. Try this new measure that uses the one we already had:
N-projets non-chargés V4_TOT = SUMX ( DISTINCT ( Charges[Groupe_Contributeur] ), [N-projets non-chargés V4] )Please mark the resolved question when you are finished and consider giving a thumbs up if the posts are useful.
Contact me privately for assistance with any large-scale BI needs, tutoring, etc.
Bless you
Community ChampionHi Anonymous
What is the expected result? I don't completely understand the logic for the calculation but try this:
N-projets non-chargés V3 = COUNTROWS(FILTER(DISTINCT('Charges'[N_Projet]), [SOMETPS22020]=0))
Please mark the question solved when done and consider giving a thumbs up if posts are helpful.
Contact me privately for support with any larger-scale BI needs, tutoring, etc.
Cheers
It seems I keep trying to answer you and the forum denies it !
Hello @AlB ,
Thank you for your answer.
I am trying to count the number of projects with 0 FTE so I can have a good picture of the amount of work for each manager that still has to be done.
Your solution works, but not perfectly as I have a difference of 2 or 3 in my results :
Expected 16
PowerBI : 18
Does that mean that Countrows is counting additionnal rows? But I can't seem to find out where or why. I will keep looking.
If you have the answer, please do enlight me !
Thank you again,
Crowd
- AlB
Anonymous
Where/how are you using the my measure? If i place it in a card visual in the file you shared I get a result of 406. Where do you get the 18?
Please mark the question solved when done and consider giving a thumbs up if posts are helpful.
Contact me privately for support with any larger-scale BI needs, tutoring, etc.
Cheers
Sorry, if its in a card its indeed 406 as a total.
18 was from one of the files out of 50 (easier to count).
Your answer is the best one I have, even if its not 100% accurate.
I still don't know why its not. Maybe it should be a Distinctcount?
Regards,Crowd
- AlB
Anonymous
What file are you looking at? Either send me a pbix with the scenario you have now (with 18 as result) or tell me how to build it with the file you shared earlier. Then I can have a look.
By the way why are some of the numbers on the "Itération_PdC" so small?
Please mark the question solved when done and consider giving a thumbs up if posts are helpful.
Contact me privately for support with any larger-scale BI needs, tutoring, etc.
Cheers