Forum Discussion
clustered column
david_63 no problem. Measures are global to the report, you can put in any table, doesn't matter.
I used example table and column name in my measure and you need to change these as per model.
The first measure is simply doing sum of amount column in a table called Table (think of SUM function in excel), 2nd measure is using first measure and making inactive relationship to active.
✨ Follow us on LinkedIn
Learn about conditional formatting at Microsoft Reactor
My latest blog post The Power of Using Calculation Groups with Inactive Relationships (Part 1) (perytus.com) I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos to whoever helped to solve your problem. It is a token of appreciation!
⚡ Visit us at https://perytus.com, your one-stop-shop for Power BI-related projects/training/consultancy.⚡
Hi and thanks again parry2k. I'm obviously missing something as nothing changed - I'm guessing I'm not interpreting fields and tables as I should in the resultant Measures formulas. Please bear with me for one more shot at this...
Could you please re-post the formula as close to the names below...?
(and do I need to subsequently modify relationships or charts?)
Table named 'DATA' 20 fields, which includes:
Field 'original due' = 30 JUNE 2021
Field 'curr due' = 31 DEC 2021
I added calculated fields to the DATA table - this results in following for the above fields (similarly for all fields in DATA table)
Field 'level orig' = "less 6m"
Field 'level curr' = "not due"
Table named 'SORT' (2 columns) to determine order of the date buckets:
not due 1
less 1m 2
less 3m 3
less 6m 4
more 6m 5
Resulting plot required is count of 'level orig' against 'level curr' by date bucket in clustered column chart.
Thanks again...