Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Let's say I have a table like below
Value Group Type
2 A old
3 B old
5 A new
3 A new
4 B new
7 B old
Then I want to create some visual based on summarized table from the above table, which is
Group P50
A XXX
B YYY
the summarized table is grouped by group and let's say I want to calculate C50 value
Here is how I create my summary table:
Summary Table = SUMMARIZE(Table, Table[Group], "P50", PERCENTILE.INC(Table[Value], 0.5))
Now my problem is :
After I create a visual, I want to add "Type" from Table as a filter, which means when I check "old" or "new" or both, visual will change based on the filter (Summary table content also be filtered).
I cannot figure out how to make this work, but I am sure I have seen report with this capability before.
Please help!
Thanks!
Hi @Leonzzheng,
Power bi does not support creating a dynamic calculated column/table based on filter/slicer. They are stored on different data levels and the parent level not respond with child-level operations.
Notice: the data level of power bi.
Database(external) -> query table(query, custom function, query parameters) -> data model table(table, calculate column/table) -> virtual table of data view(measure, visual, filter, slicer)
Regards,
Xiaoxin Sheng
@Leonzzheng , It will not. Join with a common dimension again and try.
or create the measure to use filters/slicer values
Not quite understand your suggestion, if I create measure, I cannot group by "Group" for the percentile calculation.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
109 | |
96 | |
77 | |
66 | |
53 |
User | Count |
---|---|
144 | |
105 | |
102 | |
89 | |
63 |