Forum Discussion
Group Column with Conditions
Hi schoden ，
You can follow these steps：
Step 1,import data you provide:
Step 2,use the following dax to create a new table:
Table 2 = SUMMARIZE('Table','Table'[Name],"missing value",CALCULATE( count('Table'[Term]),FILTER('Table','Table'[Term]="missing")))
Step 3，create new column in the new table :
about =
IF ( 'Table 2'[missing value] = blank(), "full",
IF ( 'Table 2'[missing value] >=1 &&'Table 2'[missing value] <=2, "1-2 Missing",
IF ( 'Table 2'[missing value] >=3 &&'Table 2'[missing value] <=4, "3-4 Missing",
IF ( 'Table 2'[missing value] >=5 , ">5 Missing"
) ) ) )
about2 = IF ( 'Table 2'[about] ="full", "full","missing")
Step 4，try the following measure:
About4 =
VAR about3 =
CALCULATE (
COUNT('Table 2'[about]),
FILTER (
ALL ( 'Table 2' ),
'Table 2'[missing value]<>BLANK()&&'Table 2'[about]=MAX('Table 2'[about]))
)
RETURN
( about3 )
Step 5,create visual base on the new table , Finally you will see:
If my answer helps you, you can mark it as an answer, thank you!
Best Regards,
Lucien
schoden check this dynamic basket analysis and that is what you need
Check my latest blog post Compare Budgeted Scenarios vs. Actuals 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 parry2k ,
Thank you for the pointing to the right resource but What I am stumbling to get is
On the x-axis /pie chart legend "Full" and 1-2 Missing , 3-4 Missing , >5 Missing together as Legend.
I can get FULL as one legend and Missing as separate with grouping of Missings.