Microsoft Fabric Community Conference 2025, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount.
Register nowThe Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.
Hello, I have two columns, called "Answer" and "Approve Status". In my report, there are visualizations of the number of different answers in "Answer" and Appruve status. "But I also need to display information about how many "Answer" statuses I have that have not yet received the "Approved" status. I'm trying to solve this issue with the formula in Power Quetry but I still don't understand exactly how to do it.I would be grateful for any advice.
Solved! Go to Solution.
@ruslan88990 If you post sample data and expected output then maybe I can mock this up and provide a solution. PQ may not be the best choice for this as this is trivial in DAX:
Measure = COUNTROWS(FILER('Table',[Approved Status] <> "Approved"))
@ruslan88990 If you post sample data and expected output then maybe I can mock this up and provide a solution. PQ may not be the best choice for this as this is trivial in DAX:
Measure = COUNTROWS(FILER('Table',[Approved Status] <> "Approved"))
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!
If you love stickers, then you will definitely want to check out our Community Sticker Challenge!