Forum Discussion
Create visual from filtered data
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.
Hi Abduvali
Please review the screen-shots of my attempt to apply your proposed solution in the link below.
You advice will be greatly appreciated.
https://1drv.ms/i/s!Ai8u-AHGz6m3iax60HZWwL66RSxy9w
Description:
(1) "age" is a text field so I get the error shown in (1).
(2) I switch to a numeric field "race" (see (3) in screen-shots) and get a different error.
(4) I replace SUM with COUNT and in (5) I get a Blank result.
(6) I remove = "Race" from the measure and I get a result of 828 which matches my filter result :-)
(7) I filter and both results match (384) - still all good :-)
In the last screen-shot, (8) I select a filter that has interactions of filters set to not affect the card in (9).
It only impacts (10).
However it does impact the measure - see (11).
I need (11) to match up with (9).
Any ideas on how to do this?
Thanks, Mark.
Can you provide some sample data? or you pbix to look at it?
- I'm also interested to know whats in your RACE column
- or at least provide a screenshot of your table view
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
This larger image may be easier to read ;-)