Forum Discussion

Skemaz's avatar
Skemaz
Advocate II
8 years ago
Solved

Create visual from filtered data

Hi In the screen-shot below, I'm trying to create a pie chart (or similar) from my filtered data. (1) The filtered numbers are being displayed in the "Card with States" by OKViz. (2) & (3) are the...
Need Help
  • Skemaz's avatar
    Skemaz
    8 years ago

    Hi

    Thanks for helping.

    What wound up working for me was the following:

    primaryFiltered = CALCULATE(COUNT(Sheet1[Colour]), ALLEXCEPT(Sheet1, Sheet1[Substance], Sheet1[Population]))

    secondaryCount = COUNT(Sheet1[Colour])

    Regards, Mark.

Abduvali's avatar
Abduvali
Skilled Sharer
8 years ago

Skemaz,

 

 

OK then create 4 measures:

  1. Race Measure = Calculate(SUM(YourTable[YourValue]),YourTable[RaceColumn] = "Race")
    1. this will let you get you 384 value, its same as the way you filtering it only by Race in that card
  2. Horse Measure = Calculate(SUM(YourTable[YourValue]),YourTable[RaceColumn] = "Horse")
    1. this will let you get you 16 value, its same as the way you filtering it only by Horse in that card
  3. Then create 3rd measure:
    1. % Measure  = [Race Measure] / [Horse Measure]
      1. then select display as Percentage from Modelling tab / Data type
  4. For the last one you will need another measure:
    1. Jockey Measure = [Horse Measure] / Distinctcount(YourTable[JockeyColumn])
      1. then select display as Percentage from Modelling tab / Data type

 

I hope this will help if you have any questions let me know.

 

 

Regards

Abduvali

Skemaz's avatar
Skemaz
Advocate II
8 years ago

Hi

Thanks for helping.

What wound up working for me was the following:

primaryFiltered = CALCULATE(COUNT(Sheet1[Colour]), ALLEXCEPT(Sheet1, Sheet1[Substance], Sheet1[Population]))

secondaryCount = COUNT(Sheet1[Colour])

Regards, Mark.