Join us for an expert-led overview of the tools and concepts you'll need to pass exam PL-300. The first session starts on June 11th. See you there!
Get registeredPower BI is turning 10! Let’s celebrate together with dataviz contests, interactive sessions, and giveaways. Register now.
I am still figuring out Power BI. I have got seemingly a very simple task: make a visual table in report view include a column from another table.
I have got:
GL - a table with invoice information, including client ID
NC - a table with credit note information, including client ID
Clients - a table with client ID as a unique identifier
Tables are not merged, but I made relationships in model view via Clients table. In the report view, I have made a table based on GL, which shows distinct count of invoices per client. I have also included a calculated column showing a ratio of credit notes to invoices like this:
I tried this as a measure, as a column in GL and in NC, after I reference it in the visual with GL columns, I only get the grand total in every row 😕
@Anonymous Please Try below Dax :
TotalNC =
CALCULATE (
COUNROWS(VALUES( 'NC'[NC number] ) ),
ALLEXCEPT ( 'NC', 'NC'[Client ID] )
)
> if its work please share your EndOutPut in table.
@Anonymous Thank You!!
User | Count |
---|---|
17 | |
14 | |
13 | |
13 | |
12 |
User | Count |
---|---|
19 | |
14 | |
14 | |
10 | |
9 |