Regarding hash one value dax function

[Bharathpowerbi]

Regarding hash one Value dax function it supports cross filter right it is not working.

Created hashonevalue on segment column trying to filter on country column but not filtering.

 

[v-sdhruv]

Hi @Bharathpowerbi ,
Just wanted to check if you had the opportunity to review the suggestions provided?
If the response has addressed your query, please accept it as a solution and give a 'Kudos' so other members can easily find it.
Thank You

[v-sdhruv]

Hi @Bharathpowerbi ,
Just wanted to check if you had the opportunity to review the suggestions provided?
If the response has addressed your query, please accept it as a solution and give a 'Kudos' so other members can easily find it.
Thank You

[v-sdhruv]

Hi @Bharathpowerbi ,
Just wanted to check if you had the opportunity to review the suggestions provided?
If the response has addressed your query, please accept it as a solution and give a 'Kudos' so other members can easily find it.
Thank You

[DataNinja777 · Accepted solution]

Hi @Bharathpowerbi ,

The reason your hashonevalue measure isn't returning a result when filtering by Country is because of how HASONEVALUE(financials[Segment]) works. Your formula:

hashonevalue = IF(HASONEVALUE(financials[Segment]), SUM(financials[Profit]), BLANK())

only returns the profit if exactly one segment is selected. When you select France in the Country slicer, it may still include multiple segments in the data, so HASONEVALUE returns false, and the measure shows blank. This is expected behavior, not a cross-filtering issue.

To confirm how many segments are active under the current filters, you can add:

Selected Segment Count = DISTINCTCOUNT(financials[Segment])

If this count is greater than one, your original measure will remain blank. The measure is working as designed, but the result depends entirely on the data context created by your slicers.

Best regards,

[Sourav_M]

Hi @Bharathpowerbi  - Can you please elaborate what exactly you are looking for and what is that iscrossfiltered measure, to analyse the problem statement.