Measure not giving filtered values after removing a dimension

Kalaivani — Sun, 16 Jun 2024 16:10:31 GMT

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

Re: Measure not giving filtered values after removing a dimension

tharunkumarRTK — Sun, 16 Jun 2024 16:38:14 GMT

Please provide the pbix file with sample data.

Need Power BI consultation, hire me on UpWork .

If the post helps please give a thumbs up

If it solves your issue, please accept it as the solution to help the other members find it more quickly.

Tharun

topic Measure not giving filtered values after removing a dimension in DAX Commands and Tips

Measure not giving filtered values after removing a dimension

Re: Measure not giving filtered values after removing a dimension