Forum Discussion
How to keep card visualization blank when report is opened
abhi87 if it is a measure you have to use aggregation, change it to something like this
Measure = IF (HASONEVALUE(CRASH_LEVEL[CRASH_KEY]), MAX(CombinedNarratives[CombinedNarrative]))✨ Follow us on LinkedIn
Check 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.⚡
abhi87 you can check if a crashkey is selected then only show the value, add a measure something like this that you can use in card visual
Measure =
IF ( HASONEVALUE ( YourTable[CrashKey] ), [Whatever you want to show on CARD VISUAL] )
✨ Follow us on LinkedIn
Check 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.⚡
parry2k When I type up the measure function I'm getting a error saying, "A single value for column 'CombinedNarrative' in table 'CombinedNarratives' cannot be determined. This can happen when a measure formula refers to a column that contains many values without specifying an aggregation such as min, max, count, or sum to get a single result." The narrative I have in my data is a text value.
This is the measure function I used
Measure = IF (HASONEVALUE(CRASH_LEVEL[CRASH_KEY]), (CombinedNarratives[CombinedNarrative]))So, the two tables I have are CRASH_LEVEL and CombinedNarratives, I have linked the CRASH_KEY between the two tables.
