Fabric is Generally Available. Browse Fabric Presentations. Work
towards your Fabric certification with the Cloud Skills Challenge.
I am trying to create a new Measure Column using DAX, How can I add the Visual level filter condition value to the DAX.
Hi @madan27,You want to create a measure or calculated column based on a particular value? If it is, you can add filter in DAX like the following formula.
Result=CALCULATE(SUM(Table[sale]),FILTER(Table, Table[column]="specificr value"))
If this is not what you want, please share more details or sample data for further analysis.Best Regards,Angelia
Thanks @v-huizhn-msft. I got the result using FILTERS.
I need to get the "specificr value" from "Visual Level Filter" condition instead of keeping static.
Hi @madan27,The "Visual Level Filter" comes from separate Table? Can you create a measure to get the value? Like "selectvalue=CALCULATE(Max(Table[column]),ALLSELECTED(Table))". If it is, please replace it to filter in DAX.Table[column]=[selectvalue]Thanks,Angelia
Check out the November 2023 Power BI update to learn about new features.
130+ sessions, 130+ speakers, Product managers, MVPs, and experts. All about Power BI and Fabric. Attend online or watch the recordings.