Forum Discussion

vedantsri's avatar
vedantsri
Icon for Helper I rankHelper I
3 years ago

How to apply a different measure based on column value?

Hi All,   I have a table that looks like this: Office Tier A High B Mid C Mid D Low   Office column is a distinct column.   Now I wanted to calculate Demand (Which is co...
Need Help
KNP's avatar
KNP
Icon for Super User rankSuper User
3 years ago

Could you post your existing measures and if possible, a screen shot of what the visuals currently look like?

 

vedantsri's avatar
vedantsri
Icon for Helper I rankHelper I
3 years ago

Hi KNP,

 

Thank you for responding!

The three measures I created are similar to this one:

HighTierDemandNeeded =
 VAR DemandDeficit = [Supply]>2*[Demand]
var tier2 = CALCULATE([Supply]-2*[Demand])
return
if(DemandDeficit,tier2,0)
 
Similarly, 
MidTierDemand =
 VAR DemandDeficit = [Supply]>1*[Demand]
var tier2 = CALCULATE([Supply]-1*[Demand])
return
if(DemandDeficit,tier2,0)
 
and so on for Low tier. 
 
The [Demand] measure that I have used in these measures is just a simple summation measure on a Column from a separate Demand table that I have connected to my Office table using the Office column. 
 
So now I want a visual that shows the right measure value (between hightierDemand, midtierdemand, lowtierdemand) based on the 'Tier' of the office selected in my slicer.
  • KNP's avatar
    KNP
    Icon for Super User rankSuper User
    3 years ago

    I think I have an understanding of what you're trying to do, just need a little more info.

     

    What is the [Supply] measure?

    It would help to have some sample data from the demand table if possible.

     

     

    • vedantsri's avatar
      vedantsri
      Icon for Helper I rankHelper I
      3 years ago

      A part of the Demand table looks like this:

      OfficeDate Needed
      A03/11/2023 5
      B03/09/2023 4
      A03/09/2023 6
      C03/06/2023 4
      B03/07/2023 6
      A03/13/2023 7

       

      So the Demand is just summing the 'Needed' column for each office in this Demand table. I Have this connected to my office table on the Office column.

       

      The [Supply] measure if similar but is working on the 'Supply' table.

      A snippet of the Supply table:

      ItemItemCreationDate Office
      1111[Some Date] A
      1112[Some Date] B
      1113[Some Date] C
      1114[Some Date] A
      1115[Some Date] C

       

      So the [Supply] measure is just supposed to do a count(Item) for each office basically. So in this snippet, Office A would have the value 2, B=1 and c=2. I have this Supply table connected to my original office table on the 'Office' column.

       

      Thanks.

      • KNP's avatar
        KNP
        Icon for Super User rankSuper User
        3 years ago

        Am I correct in assuming this is your numbering for tier in the measures?