Need Help Summarising Visualisation Table

[JoeyHenry]

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

[Ashish_Mathur · Accepted 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.

[v-lili6-msft · Accepted solution]

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

[JoeyHenry]

Thank you lean.

I can use the formula also.

Cheers,

JH

[Ashish_Mathur · Accepted 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.

[JoeyHenry]

Hi Ashish,

Thank you for this response. I can use this.

Cheers,

JH

[Ashish_Mathur]

You are welcome.