@PowerBl @powerbi2
Hi,
I have a problem in ffiltering measure in Power BI. Can anyone help me with this? Thanks in advance!!!
Here is the case:
I have 2 measures that calculates count of the selected Providers from 2 different slicers which gives '1' for the selected providers. Here is the measure -
CountProviderCategory =
VAR selectedproviders = CALCULATETABLE(VALUES('Provider Attributes'[ProviderName]))
RETURN
CALCULATE
(
COUNTROWS('BarChart'),
FILTER(
'BarChart',
'BarChart'[category] = "Provider" && 'BarChart'[ProviderName] IN selectedProviders
),
TREATAS(VALUES('Provider Attributes'[ProviderName]), 'BarChart'[ProviderName])
)
CountComparisonCategory =
VAR selectedproviders = CALCULATETABLE(VALUES('UnionTable'[Value]))
RETURN
CALCULATE
(
COUNTROWS('BarChart'),
FILTER(
'BarChart',
'BarChart'[category] = "Comparison" && 'BarChart'[ProviderName] IN selectedProviders
),
TREATAS(VALUES('UnionTable'[Value]), 'BarChart'[ProviderName])
)
CombineData =
IF(
([CountComparisonCategory] > 0
||
[CountProviderCategory] > 0),
"0",
"1"
)
So I added a table visual like below and filtered the table for the CombineData= 0. My issue is when I remove the diemension from the table, the Visits sum is showing the sum of all dimension values instead of sum of values for the filtered countprovidercategory.
In te table below, the total visits value is 158. But when I remove the dimension from the table, the sum is the sum of all dimension values which is not right. I want 158 only to be shown there even after removing the Dimension from the table visual.
Table Visual while adding Dimension to the table and after removing it from the table:
| category | CountProviderCategory | CountComparisonCategory | Sum of TotalVisits | Dimension |
| Comparison | | 1 | 89 | Val1 |
| Provider | 1 | | 28 | Val2 |
| Provider | 1 | | 26 | Val3 |
| Provider | 1 | | 15 | Val4 |
| Provider | 1 | | 11 | Val5 |
| category | CountProviderCategory | CountComparisonCategory | Sum of TotalVisits |
| Comparison | | 1 | 106761 |
| Provider | 4 | | 35587 |
