Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hi, I'm having a problem and I don't know how to solve it. I have a table with the invoices and each invoice is repeated x number of times depending on how many items it has. Create a table showing the number of kilos for each voucher and in Cantidad de Comprobantes (show how many vouchers are with the same number)
until here I come well, now I want to make a formula that gives me back the amount of vouchers that exceed 1000 kilos. the column reference is : cantidad de kilos > 1000
for example in this case I would have to return an amount of 8 vouchers that exceed 1000 kilos
here can download a sample pbix. https://we.tl/t-9qXezjgP3S
in this sample de count of rows that exceed 1000 kg are 23
Solved! Go to Solution.
Please find the formula
Measure = CALCULATE(COUNTX(FILTER(VALUES(ventasxdia[numero y tipo]),[kg quantity]>=1000),[kg quantity]))
pbix -https://www.dropbox.com/s/b4w7u1ykucwmbrw/sample%20power%20bi.pbix?dl=0
Appreciate your Kudos. In case, this is the solution you are looking for, mark it as the Solution. In case it does not help, please provide additional information and mark me with @
Thanks.
My Recent Blog - https://community.powerbi.com/t5/Community-Blog/Comparing-Data-Across-Date-Ranges/ba-p/823601
Please find the formula
Measure = CALCULATE(COUNTX(FILTER(VALUES(ventasxdia[numero y tipo]),[kg quantity]>=1000),[kg quantity]))
pbix -https://www.dropbox.com/s/b4w7u1ykucwmbrw/sample%20power%20bi.pbix?dl=0
Appreciate your Kudos. In case, this is the solution you are looking for, mark it as the Solution. In case it does not help, please provide additional information and mark me with @
Thanks.
My Recent Blog - https://community.powerbi.com/t5/Community-Blog/Comparing-Data-Across-Date-Ranges/ba-p/823601
@jdelacrettaz in your sample dataset i'm getting 23, is this what you are expecting the result to be?
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.
User | Count |
---|---|
94 | |
83 | |
78 | |
75 | |
66 |
User | Count |
---|---|
115 | |
105 | |
93 | |
65 | |
62 |