Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and a 50 percent discount on exams.
Get startedEarn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hi,
I'd like to always apply the same measure to the matrix independent of the data table.
For example the Balance Sheet, Total current assets is always the sum of say rows 10-15.
So the data table [TB] would become some sort of generic lookup for the values already in the matrix.
Total current assets =
calculate([TB],BS[Sort index] >= 10,BS[Sort index] <= 15)
Hope that makes sense.
Thanks for reading.
Solved! Go to Solution.
Hi @smitpau ,
This is impossible,unless the datasource names and column names of different data sources are the same.
Best Regards,
Liang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi @smitpau ,
This is impossible,unless the datasource names and column names of different data sources are the same.
Best Regards,
Liang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Thanks @V-lianl-msft good to know was treating it like an Excel cell which realise you can't do.
HI @smitpau
If I understand your ask, below is what I would do.
Measure = CALCULATE(SUM('BS'[TB]),BS[Sort index] >= 10 && BS[Sort index] <= 15)
Hope it resolves your issue? Did I answer your question? Mark my post as a solution! Appreciate your Kudos, Press the thumbs up button!! Linkedin Profile |
Hi Pranit,
Thanks for the help.
The idea is that as the TB (data source) can change the measure would just sum the values of certain rows rather than rely on the data source. So the measure wouldn't refer to a single data source.
User | Count |
---|---|
91 | |
77 | |
71 | |
64 | |
58 |
User | Count |
---|---|
106 | |
97 | |
76 | |
63 | |
60 |