Forum Discussion

Skemaz's avatar
Skemaz
Icon for Advocate II rankAdvocate 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.

Skemaz's avatar
Skemaz
Icon for Advocate II rankAdvocate II
8 years ago

Hi Abduvali

Thanks for your prompt reply.

The user selects filters in the "Race Filters" this reduces the number shown in (2) in the screen-shot. The number is just a single value in a Card. I have edited the filters interactions so that the filters in "Race Filters" apply to card (2) and (1).

However, the filters in "Horse Filters" only affect (1) and not (2).

The value could come from any field, but I have used a count of the "age" field to get the number.

In the screen-shot, (4) shows 3 rows representing the Jockey and Horse combination which is the 3 you asked about.

Thanks, Mark.

Abduvali's avatar
Abduvali
Icon for Skilled Sharer rankSkilled 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