Forum Discussion

JCuoco's avatar
JCuoco
Regular Visitor
4 years ago

Creating New Value from Previous Values

I am looking to create a new measure/column from a previous field that has more than one value in it.   We have a field that outlines two different types of visit types and i want to see which indi...
JCuoco's avatar
JCuoco
Regular Visitor
4 years ago

 

 

Below is a fake data set, as i work in healthcare, but this will be helpful still.

 

Patients 1-12 have visits at primary but patients 1-3 also have speciality visits ..... i would want the patients with both values to be called "both" and while the indivudals with one type of facility is just labeled as "one" in a new column. 

 

Anonymous's avatar
Anonymous
Not applicable
4 years ago

Hi JCuoco ,

You can create a calculated column as below to get it:

Column = 
VAR _count =
    CALCULATE (
        DISTINCTCOUNT ( 'Table'[Type of Facility] ),
        FILTER ( 'Table', 'Table'[Patient] = EARLIER ( 'Table'[Patient] ) )
    )
RETURN
    IF ( NOT ( ISBLANK ( _count ) ), IF ( _count = 1, "One", "Both" ), BLANK () )

Best Regards

  • JCuoco's avatar
    JCuoco
    Regular Visitor
    4 years ago

    appreciate the help but this didnt work - i think i know why it didnt, as i am using two separate data sets. I probably should have mentioned that previosly. Column A and B are in different sets. 

    Apologies for that



    • tamerj1's avatar
      tamerj1
      Icon for Community Champion rankCommunity Champion
      4 years ago

      JCuoco 

      Would you please provide more details about your data?

    • Anonymous's avatar
      Anonymous
      Not applicable
      4 years ago

      Hi JCuoco ,

      Could you please some sample data from those two "data sets" which column A and B located in? Is there any relationship between these two "data sets"? If yes, please provide the relationship info. It is better if you can share a simplified pbix file with me. You can refer the following thread to upload your file in the community. Thank you.

      How to upload PBI in Community

      Best Regards