Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hello,
First of all, thanks for user and people who daily helps the PBI biginners.
I did a PBI file who nearly works perfectly. I have one problem with ranks. I explain the issue :
I have amounts that are associated with segments ("FDR"). for example the analytic code level 2 "Y01-A" is associated with segment "Materials", the code level 2 "Y01-B" with segment "Systems". The codes level 2 "Y01-A" and "Y01-B" belong to the the code level 1 "Y01".
When I do calculations with measures I sometimes need to add a amount at the level 1 without to know the decomposition between level 2.
Y01-A = 20
Y01-B = 10
Y01 >>> I must add 5.
When I do the total (with a measure), the visual table give me correctly the result of 35.
But when I look at the result by segment and level 1, PBI doesn't give 35, but 25 for semgment "Materials" and 15 for segment "Systems".
I think the problem is the add of 5 is not apply to one segment, so PBI doesn't manage to ventiate correctly the ass of 5.
According to y'all, how to get PBI to calculate the right result without add 5 in each segment but divide the 5 in the segments ?
The goal is to have total of 35 by segment. What is the right logic to apply please ?
Thanks for help.
@Dazou ,
Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.