Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric 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!!
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
Ask questions in Eventhouse and KQL, Eventstream, and Reflex.
User | Count |
---|---|
71 | |
36 | |
21 | |
19 | |
15 |
User | Count |
---|---|
125 | |
37 | |
29 | |
29 | |
24 |