Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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 😕
@as65fgdax 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.
@as65fgdax Thank You!!
User | Count |
---|---|
57 | |
21 | |
19 | |
18 | |
16 |
User | Count |
---|---|
85 | |
80 | |
52 | |
37 | |
22 |