Forum Discussion
calculation with different groups
Hi nicolasawa
Can you show an example based on actual data of what you are trying to accomplish? And ideally share the pbix
|
|
Please accept the solution 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. |
hello, for exemple,
I have 4 materials of the red type. One have a lifetime of 2 years and the 3 others have the life time of 3 :
and 3 materials of the blue type. all three have a lifetime of 2 years
| type | lifetime (year) | number of material by type and lifetime | total number of material by type |
| red | 2 | 1 | 4 |
| red | 3 | 3 | 4 |
| blue | 2 | 3 | 3 |
when the user filter by type red and blue, the mesure I want is the sum of all the "number of material by type and lifetime" divided by the "total number of material by type". But the first two rows of the last column are going to be counted 2 times instead of one. I want it to be counted only one time. The result of the mesure I want is : (1+3+3)/(4+3). Not (1+3+3)/(4+4+3)