Forum Discussion

alecjbeckett's avatar
alecjbeckett
Frequent Visitor
9 years ago
Solved

True or False Percent Gauge

Hi All,   I am trying to convert the below table to a gauge.   What i would like to have the gauge show Cases solved that are TRUE as a percentage of the total number of CASE IDs.   Bit of a po...
Need Help
  • Anonymous's avatar
    Anonymous
    9 years ago

    Create 3 Measures.  First measure would be a simple "CountRows" measure.  That will give you the total number of cases.  This measure will change depending on your filter context.  Next create a 2nd measure which is going to count the number of True rows, this can be done doing something like:

    CountTrue = CALCULATE(
    COUNTROWS('YourTable'),
    'YourTable'[Case Solved?] = TRUE()
)

    Lastly the 3rd measure is what is your percentage, which will be the [CountTrue] / [CountAll]

     

Anonymous's avatar
Anonymous
Not applicable
9 years ago

Hi Guyloucou, i'd love to help you but I can't for the life of me work out what you are asking.  Your question didn't seem to make any sense.

Guyloucou's avatar
Guyloucou
Frequent Visitor
9 years ago

Sorry, my first language is French. Let me give you more details. I would like to write a measure to know how many projects are deliver to the target date anticipate. Can you help me?

  • Anonymous's avatar
    Anonymous
    Not applicable
    9 years ago

    Something like:

    CountTrue = CALCULATE(
    COUNTROWS('YourTable'),
    'YourTable'[Completed] = TRUE(),
    'YourTable'[DeliveredDate] <= 'YourTable'[TargetDate]
)
    • Guyloucou's avatar
      Guyloucou
      Frequent Visitor
      9 years ago

      Thank you Ross, I tried this and I received an error message:

       

      CountTrue = CALCULATE(

      COUNTROWS('My Table'),

      'My table'[Total days delay design] = TRUE(),

      'My table'[Design closing date] <= 'My table[Design requestdate]

       

      The expression contains multiple columns, but only a single colomn can be used in a True/False expression that is used as a table filter expression.

       

      In the column "Total days delay design" sometimes I have a number of days and sometimes nothing. Can you tell me what is wrong, please.

       

      Thanks in advance :-)

       

      • Anonymous's avatar
        Anonymous
        Not applicable
        9 years ago

        Looks like i've stuffed up and given you a bum steer.  Ok lets go another direction.  Create a new custom column with the formula:

        CountMe = IF(
	'My table'[Design closing date] <= 'My table[Design requestdate],
	1,
	0
)

        Then use it within:

        CountTrue = CALCULATE(
	COUNTROWS('My Table'),
	'My table'[Total days delay design] = TRUE(),
	'My table'[CountMe] = 1
)