Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Hi Team,
I have created an matrix and in the matrix, I have column called Traffic Spikes. That column have values of 0 or 1. I put that column in the values field on matrix. Then I'm doing Max of Traffic Spikes. Is there way to turn 0 or 1 to Yes or No without impacting the Max of Traffic Spikes? I would like to keep the maximum
Thanks
Solved! Go to Solution.
@Anonymous try this
Yes or No Measure =
IF ( MAX ( Table[Traffic Spikes] ) = 0, "No" ,
IF ( MAX ( Table[Traffic Spikes] ) = 1, "Yes" )
)
Subscribe to the @PowerBIHowTo YT channel for an upcoming video on List and Record functions in Power Query!!
Learn Power BI and Fabric - subscribe to our YT channel - Click here: @PowerBIHowTo
If my solution proved useful, I'd be delighted to receive Kudos. When you put effort into asking a question, it's equally thoughtful to acknowledge and give Kudos to the individual who helped you solve the problem. It's a small gesture that shows appreciation and encouragement! ❤
Did I answer your question? Mark my post as a solution. Proud to be a Super User! Appreciate your Kudos 🙂
Feel free to email me with any of your BI needs.
@Anonymous you can create a measure to get yes and no value
Yes and No Measure =
IF ( MAX ( Table[Traffic Spikes] ) = 0, "No", "Yes" )
Subscribe to the @PowerBIHowTo YT channel for an upcoming video on List and Record functions in Power Query!!
Learn Power BI and Fabric - subscribe to our YT channel - Click here: @PowerBIHowTo
If my solution proved useful, I'd be delighted to receive Kudos. When you put effort into asking a question, it's equally thoughtful to acknowledge and give Kudos to the individual who helped you solve the problem. It's a small gesture that shows appreciation and encouragement! ❤
Did I answer your question? Mark my post as a solution. Proud to be a Super User! Appreciate your Kudos 🙂
Feel free to email me with any of your BI needs.
@Anonymous try this
Yes or No Measure =
IF ( MAX ( Table[Traffic Spikes] ) = 0, "No" ,
IF ( MAX ( Table[Traffic Spikes] ) = 1, "Yes" )
)
Subscribe to the @PowerBIHowTo YT channel for an upcoming video on List and Record functions in Power Query!!
Learn Power BI and Fabric - subscribe to our YT channel - Click here: @PowerBIHowTo
If my solution proved useful, I'd be delighted to receive Kudos. When you put effort into asking a question, it's equally thoughtful to acknowledge and give Kudos to the individual who helped you solve the problem. It's a small gesture that shows appreciation and encouragement! ❤
Did I answer your question? Mark my post as a solution. Proud to be a Super User! Appreciate your Kudos 🙂
Feel free to email me with any of your BI needs.
@parry2k I think i found the issue. I have an filter which looks at critical sites for traffic. When I use that filter when measure is selected in value column, Filter doe not work with measure. It works without messure. Do i need to add something to measure so Filter will work?
@Anonymous so surely I don't see the whole picture, if you are ok, share pbix file wiht sample data and remove any sensitive information before sharing.
Subscribe to the @PowerBIHowTo YT channel for an upcoming video on List and Record functions in Power Query!!
Learn Power BI and Fabric - subscribe to our YT channel - Click here: @PowerBIHowTo
If my solution proved useful, I'd be delighted to receive Kudos. When you put effort into asking a question, it's equally thoughtful to acknowledge and give Kudos to the individual who helped you solve the problem. It's a small gesture that shows appreciation and encouragement! ❤
Did I answer your question? Mark my post as a solution. Proud to be a Super User! Appreciate your Kudos 🙂
Feel free to email me with any of your BI needs.
@parry2k I can try. I have powerbi with million rows of data. Tough to share the file. I have column in data called CriticalSiteYn. CriticalSiteColumn is in different table. Value of that column is = Critical or null. Do I need to create an another measure so that criticalsite will work on that measure we just created. If i remove the filter, measures works fine on all data but doesn't filter when selecting critical.
User | Count |
---|---|
140 | |
113 | |
104 | |
77 | |
65 |
User | Count |
---|---|
135 | |
116 | |
101 | |
71 | |
61 |