Microsoft Fabric Community Conference 2025, March 31 - April 2, Las Vegas, Nevada. Use code FABINSIDER for a $400 discount.
Register nowGet inspired! Check out the entries from the Power BI DataViz World Championships preliminary rounds and give kudos to your favorites. View the vizzies.
I know that it sounds like a beginner level problem, but being a seasoned Power BI guy I've ran into a quite weird scenario that upon comparing two measures, the equal to comparison is not working correctly.
Here's the DAX:
Solved! Go to Solution.
Please supply some data to test and examples of when this does not work.
How are you calculating the 2 measures [Total Activities] and [Yearly Average of Activities] ?
What data types are these measures? By their naming I'd expect [Total Activities] to be Whole Number and [Yearly Average of Activities] to be a Decimal?
If so, could it be that the decimal is formatted to look like a whole number, thereby giving the impression that both measures are equal at times?
Regards
Phil
Proud to be a Super User!
@PhilipTreacy I found out partially it was due to formatting (decimal formatted as whole number), topped up with some filter context issues which I took care of.
Cheers mate. 🙂
Please supply some data to test and examples of when this does not work.
How are you calculating the 2 measures [Total Activities] and [Yearly Average of Activities] ?
What data types are these measures? By their naming I'd expect [Total Activities] to be Whole Number and [Yearly Average of Activities] to be a Decimal?
If so, could it be that the decimal is formatted to look like a whole number, thereby giving the impression that both measures are equal at times?
Regards
Phil
Proud to be a Super User!
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code FABINSIDER for a $400 discount!
Check out the February 2025 Power BI update to learn about new features.
User | Count |
---|---|
126 | |
111 | |
73 | |
64 | |
46 |