Article: Using HASONEVALUE in a DAX IF statement

[Ken Puls]

You can view the page at http://www.excelguru.ca/content.php?...X-IF-statement

[vineeth]

hi ken,

this is an excellent article. I have been looking all over for an explanation of HASONEVALUE. This will help me complete some of the reports i was building for finance myself.

Thanks and Regards
Vineeth

[mubb]

Hi Ken,
Really enjoyed your video at PowerPivot School. Thank you for great, detailed instructions. This post is also very illuminating and useful. One quick question.... the formula
IF(VALUES(tblCOA[AccGroup])= "Expenses",-1,-1)
should it not be IF(VALUES(tblCOA[AccGroup])= "Expenses",-1,1)
this seems to be the case the first time it was introduced but then uses -1 in second argument, for which I didn't understand the logic/reasoning, your guidance would be most appreciated.

Many thanks.... and keep up the good work.

Regards,
Mubbasher.

[amit4blog]

Hi Ken,

It's a great post. I am looking some extra ordinary article, which i found here.Thanks for publishing.

[rwilson]

Hi Ken

Like others I found your post very helpful - thanks.

One thing I am having a bit of trouble with is taking this down to another level ie the next account sub group. For example, what if "Alcoholic Beverages" was broken down into "Beer", "Wine", "Spirits" etc and "Cost of Sales" was broken down into "Food", "Beverages", "Condiments" etc.

I can get the individual items eg "Beer" and "Food" to display correctly, but not the subtotals for "Alcoholic Beverages" or "Cost of Sales". Any thoughts on how this might be done?

Cheers