Calculated Column based on Column Value

Hi Jadegirlify - Yes you can create it by using below measures and display the output in table chart from same original table.

Measure for Onsite Count:

Onsite Count =
CALCULATE(
COUNT('OriginalTable'[Work Location]),
'OriginalTable'[Work Location] = "Onsite"
) +0

Measure for Virtual Count:

Virtual Count =

CALCULATE(

    COUNT('DWLP'[Work Location]),

    'DWLP'[Work Location] = "Virtual"

)+0

 

 Measure for Total Onsite/Virtual:

 

Total Onsite/Virtual = [Onsite Count] + [Virtual Count]

 

Measure for Work Location Type:

 

Work Location Type =

SWITCH(

    TRUE(),

    [Onsite Count] = 0 && [Virtual Count] > 0, "Virtual",

    [Onsite Count] > 0 && [Virtual Count] = 0, "Onsite",

    [Onsite Count] > 0 && [Virtual Count] > 0, "Onsite & Virtual"

)

 

 

 

 

Did I answer your question? Mark my post as a solution! This will help others on the forum!
Appreciate your Kudos!!