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.

Skemaz's avatar
Skemaz
Advocate II
8 years ago

Hi

I created a simple report (.pbix at the link below) to explain my requirement better,

Also, please check out these screen-shots with explainations below.

Thanks, Mark.

This is the link to  zip file containing the .pbix and data source click here

 

Skemaz's avatar
Skemaz
Advocate II
8 years ago

This larger image may be easier to read ;-)