topic Re: Regarding hash one value dax function in DAX Commands and Tips

Regarding hash one value dax function

Bharathpowerbi — Mon, 21 Apr 2025 13:11:11 GMT

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.

Re: Regarding hash one value dax function

Sourav_M — Mon, 21 Apr 2025 13:55:38 GMT

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

Re: Regarding hash one value dax function

DataNinja777 — Mon, 21 Apr 2025 14:34:16 GMT

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,

Re: Regarding hash one value dax function

v-sdhruv — Sat, 26 Apr 2025 11:22:42 GMT

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

Re: Regarding hash one value dax function

v-sdhruv — Tue, 29 Apr 2025 12:23:09 GMT

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

Re: Regarding hash one value dax function

v-sdhruv — Sun, 04 May 2025 07:13:05 GMT