Hi Ruth, thanks for the video. I think it would be great if you can create another video for HASONEVALUE that is more simple than this one, meaning that it would be a better example one that doesn't use other functions. Thanks again.
HASONEVALUE checks for only distinct values in a group, but you are getting results even if the column isn't having distinct values? How is this possible?
Thanks Ruth for the video! I have one comment on this. When using combination of hasonevalue and values function to change current filter context, the visual returns an error although DAX is absolutely correct. This is when you use, for example, matrix and throw one field in row and another one in column. When both fields are under row, I don’t get an error. Any reflection? Consolidated Plan = IF ( HASONEVALUE ( GL_Map[G/L Description] ) && VALUES(Company_Map[Company Name])"AT", SUM ( 'Plan Cost'[2020 Planned Cost] ), CALCULATE ( SUM ( 'Plan Cost'[2020 Planned Cost] ), FILTER ( ALL ( GL_Map[G/L Description] ), GL_Map[G/L Description] "Support Service" ) ) )
Hi Ruth, billion thanks on the video. However, I just mixed up, the HASONEVALUE does it mean the whole column has only one single value which means all the value inside the column is the same? or just only one value being selected?
Hi Ruth..! i have country and sales columns my requirement is, if i filtered "top5" in slicer i need to get top5 country wise sales in table visual same as like in this video i am trying but, can't getting could you please let me know the steps and dax for that requirement Thanks:)
Thanks for the video Ruth! It really helps to understand the idea of the function. Great job !
+Victor Friesen Thanks Victor and thanks for your support :)
/Ruth
Great explanation and example. Thank you for making it clear how it can be utilized.
Hi Ruth, thanks for the video. I think it would be great if you can create another video for HASONEVALUE that is more simple than this one, meaning that it would be a better example one that doesn't use other functions. Thanks again.
Noted :)
/Ruth
HASONEVALUE checks for only distinct values in a group, but you are getting results even if the column isn't having distinct values?
How is this possible?
Thanks Ruth for the video!
I have one comment on this. When using combination of hasonevalue and values function to change current filter context, the visual returns an error although DAX is absolutely correct. This is when you use, for example, matrix and throw one field in row and another one in column. When both fields are under row, I don’t get an error.
Any reflection?
Consolidated Plan =
IF (
HASONEVALUE ( GL_Map[G/L Description] )
&& VALUES(Company_Map[Company Name])"AT",
SUM ( 'Plan Cost'[2020 Planned Cost] ),
CALCULATE (
SUM ( 'Plan Cost'[2020 Planned Cost] ),
FILTER (
ALL ( GL_Map[G/L Description] ),
GL_Map[G/L Description] "Support Service"
)
)
)
Nice video again Ruth :-)
+Kenny McMillan You welcome Kenny :)
/Ruth
Loves these videos. Thanks ❤️
My pleasure!!
Hi Ruth, billion thanks on the video. However, I just mixed up, the HASONEVALUE does it mean the whole column has only one single value which means all the value inside the column is the same? or just only one value being selected?
Great, many thanks
You welcome!
/Ruth
Hi Ruth..!
i have country and sales columns
my requirement is, if i filtered "top5" in slicer i need to get top5 country wise sales in table visual
same as like in this video
i am trying but, can't getting
could you please let me know the steps and dax for that requirement
Thanks:)
excellent
Wonderful :)
/Ruth
In the same measure, I meant.
Hi Ruth, Can I use both active and inactive relationships in a single measure?
No, the actife is what remains but inactive is not the one that is used. You can switch between the two. Turn one actife and the other inactive..