Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
I have this visualisation table. The purpose of this table is to show Purchasing Orders that were created after invoice date. I created a Key Measure subtracting Table1.[Document Date] and Table2.[Earliest Invoice Date] = [Difference].
Now I want to create a visualisation table that would tell me how many Purchasing Orders were created after invoice. For example 31Second Pty Ltd have 5 instances and Ergo Asia have 2 instances. How do I do this?
(All data are dummy inputs)
Thanks for the help.
JoeyHenry
Solved! Go to Solution.
Hi,
Create another visual with vendor names in the row labels. Write this measure
=COUNTROWS(FILTER(VALUES(Data[PO Number]),[Difference]>0))
If my solution does not work, then share the link from where i can download your PBI file.
hi, @JoeyHenry
You could use COUNTAX Function to add a measure for it.
Logic like this post, just use COUNTAX instead of SUMX.
Measure= COUNTAX(summarize table,[Difference])
https://community.powerbi.com/t5/Quick-Measures-Gallery/Measure-Totals-The-Final-Word/m-p/547907
If it is not your case, please share sample pbix file or some data sample and expected output. You can upload it to OneDrive and post the link here. Do mask sensitive data before uploading.
Best Regards,
Lin
hi, @JoeyHenry
You could use COUNTAX Function to add a measure for it.
Logic like this post, just use COUNTAX instead of SUMX.
Measure= COUNTAX(summarize table,[Difference])
https://community.powerbi.com/t5/Quick-Measures-Gallery/Measure-Totals-The-Final-Word/m-p/547907
If it is not your case, please share sample pbix file or some data sample and expected output. You can upload it to OneDrive and post the link here. Do mask sensitive data before uploading.
Best Regards,
Lin
Thank you lean.
I can use the formula also.
Cheers,
JH
Hi,
Create another visual with vendor names in the row labels. Write this measure
=COUNTROWS(FILTER(VALUES(Data[PO Number]),[Difference]>0))
If my solution does not work, then share the link from where i can download your PBI file.
Hi Ashish,
Thank you for this response. I can use this.
Cheers,
JH
You are welcome.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
96 | |
93 | |
82 | |
70 | |
64 |
User | Count |
---|---|
118 | |
106 | |
93 | |
79 | |
72 |