Dimensions Combine

[BarPinto]

Hey,

how can i combine 2 values of Dimension into one?

If bill num ever got the number one return only 1.

I want to see the bill number only one time in the table and at the end put it in KPI.

[Andrea_Bertazzo]

Hi BarPinto,

Thanks for writing in the Community. Could you, please, better describe your question? I am not sure I can understand what is your goal.

Thanks

[BarPinto]

hey,

thank you for your reply.

what i meant is in case i have same dimension value ( name ) like the table: both line has the same bill num - PC90000798, but the measure im calculating gives me 2 different values - the calculate is matrix that check if the bill ever been in a status.

how can i make condition that if the bill number ever got the value 1, always return 1 for this bill number ??  

today i get: 2 lines

what i want to see: 1 line with the value 1 if ever got 1, else 0 if never got 1.